Comparison acumulatte

[#1]

Good evening,

I have a table with the number of open call day.

My boss wants data to be accumulated prior to, or perhaps 12 days 365 days earlier to remove the seasonality of the year.

And my boss wants a light indicating: If today was lower than yesterday: ok (green), if today is the same as yesterday: warning (yellow), today is greater than yesterday: poor (red)

And every day he'll open up that QOL, reload the data to see the comparison.

Any tips?

Thanks a lot

Gledson

[#2]

Hello,

Can you try to add these lines in your script and use the fields in you graphs.

Hope that help

Philippe

temp:

load

DataOco

,

sum

(NumOco) as

SumNumOco

resident

OcorrênciaSérieHistórica

group

by

DataOco

order

by DataOco

;

LastDayTable:

load

DataOco

,

SumNumOco

as SumNumOco

,

if

(DataOco<>previous(DataOco),previous(SumNumOco)) as

LastSumNumOco

resident

temp2;

drop

table

temp2;