Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i created a straight table containing fields like transacation type, today's transaction, yestreday tx count, last 7 days count, last 28 days count
i have given the dimension as transaction type and in expressions other 4.
for Todays tx i have written an expression like : =sum({<Day={"=Num(Max(Day))"}>}SumofTxn)
For yestredays i ahve written an expression like : sum({<Day={"=Num(Max(Day)-1)"}>}SumofTxn)
but for other two i am not getting how to write expression.
please help
all last 7 days
Try like:
Today : =sum({<Day={"$(=Max(Day))"}>}SumofTxn)
Yestesrday : =sum({<Day={"$(=Max(Day)-1)"}>}SumofTxn)
Last 7 days : =sum({<Day={">$(=Max(Day)-7) <=$(=Max(Day))"}>}SumofTxn)
Last 28 days : =sum({<Day={">$(=Max(Day)-28) <=$(=Max(Day))"}>}SumofTxn)
Note: If you select any date field and wish to see corresponding result, you might have to pass that field in all the set expressions like:
Yestesrday : =sum({<Date, Day={"$(=Max(Day)-1)"}>}SumofTxn)