expression help

[srujanaponnuru]

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

[srujanaponnuru]

all last 7 days

[tresesco · Accepted solution]

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)