Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anybody help me with below set analysis, what is wrong with expression
=Sum({<Date={">=$(=QuarterStart(AddmMonths(AddYears(Today(),-3),1))"}>}Quantity)
what do you want to achieve?
Previous quarter ?
Sum({<Date={">=$(=Num(QuarterStart(AddYears(Max(Date),-1)))) <=$(=Num(AddYears(Max(Date),-1)))"}>}Sales)
I want to display precious 12 Quarter data it means Previous 3 Years
may be this?
sum({<Date = {">=$(addmonths(monthstart(today()), -36) <=$(today())"}>} Amount)
I tried this, still no working..
Date format is also matching but don't know why data is not coming.
try this
sum({<Date = {">=$(=addmonths(monthstart(today()), -36) <=$(=today())"}>} Amount)
No luck . I wonder why this simple set analysis is not working
share your sample app?
or
could you share your date field values in filterpane?
Its working in table expression but not in Line Chart
Do we need to do any setting at Line Chart level