Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
Im building a straight table chart where I wish to only have the data when Period_dte = Yesterday
Date is a demension and I have tried a calculated demension too and I cant quite get it to work
Has anyone got any advice please ?
Thanks
A
I have tried :
GetFieldSelections(Period_dte=date(today()-1)
But its not working
Hi,
Use calculated dimension as if(Period_dte=date(today()-1),Period_dte)
Its better to use set analysis instead of calculated dimension like below for the expression
Sum({<Period_dte={'$(=date(today()-1))'>} FieldName)
Celambarasan
Hi,
Use calculated dimension as if(Period_dte=date(today()-1),Period_dte)
Its better to use set analysis instead of calculated dimension like below for the expression
Sum({<Period_dte={'$(=date(today()-1))'>} FieldName)
Celambarasan
Hi Celambarasan
I tweaked your answer and in the load statement put
IF(Period_dte = Today() - 1, 'Yes',null()) as
So I could then load as a demension and tick if Null() hide , so only yesterday info showed
Thanks for your help
A