Widgets - visualising current month only : is this possible?

[jasonhillage-tn]

Hi everyone. Sorry if this is something simple but I'm struggling to get my head around this in our current Geneva system.

I have 2 automated indicators set to pick up data for the current month, running daily. From these 2, a formula indicator calculates a spline graph as %.

Pretty simple stuff so far.

The problem, however, is that I can't see a way to get the widget to only display the current month (which should change in line with the date).

I've set the widget to use MAX as time period, which is going to be a problem going forward as the data extends. (I believe this can be cleared down for data with Helsinki but that doesn't address this issue fully.) If I set a 1 month view then that gives me the view for the past 30-31 days, again not quite what I'm after.

All I would like it to do is show me daily data from 1st of current month to the end of the current month, rolling on as time progresses. The solution currently evades me. Is anyone able to :

a) advise if this is possible within SNOW

b) point me on the right road if it is please

?

Appreciate any assistance on this - if you need more info to clarify what I'm after please feel free to ask

Thanks

[Vincent Loffel1 · Accepted solution]

Hi Jason,

Currently this is not possible. You can only set it to show the last month (30days) of data, but not to show only the current month.

Cheers,

Vincent

[jasonhillage-tn]

Many thanks for the info Vincent. Do you happen to know if this is something that may be on the cards for a near-future release at all?

[Vincent Loffel1]

Hi Jason,

Not that I know off.

Cheers,

Vincent

[Arnoud Kooi]

Not recommended, but if you only use the 2 indicators for this purpose, you could delete the older scores in a scheduled job

//run this on second of month, after results   of 1th day are collected

var d = new GlideDateTime(); //used to convert to format used in pa_scores

var intdate = "" +   d.getYear() + d.getMonth() + "01";

var gr = new GlideRecord('pa_scores');

gr.addQuery("indicator","IN","sysid1,sysid2")

gr.addQuery("start_at","<",intdate);

gr.query();

gr.deleteMultiple();