Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
I want to do a measure pointer with segments and different colors, where I can see :
- sale of last year per day
-plansale per day
actual sale per day
It should be dynamic, in depency of a date.
Does anybody have a idea?
best regards
wuensche
Last = sum({<year = {'=year(=date(today())) - 1'} >} sales) / 365
PlanSale = sum(plansale) / days if necessary
Actual = sum(actual)
??