Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I have one DATE FIELD as DD/MM/YYYY format.
I'm trying to plot 2 charts:
One with last 2 years, and another with last 13 months.
How Can I use on my SALES value?
Tks
You can set the day moth year formact using:
Year(Date("Data field",'DD/MM/YYYY')) as Y,
Month(Date("Data field",'DD/MM/YYYY')) as M,
Day(Date("Data field",'DD/MM/YYYY')) as D,
after this your can have the fields to separate what you want
Hi Paulo,
The date field worked. How Can I use the set analysis to show just the last 2 years and another with last 12 months?
Tks!
aggr(ONLY({<YEAR={'2017'}>} Field ),Field)
Hi Vishsaggi.
I'm trying to solve the last 13 months, but I couldn't get it.
My expression
SUM({< DATA = {">=$(=Num(Floor(AddMonths(DATA, -13)))<=$(=Num(Floor(Max(DATA))))"} >}CART_ATRASO_31a60)