GetFieldSelections Yesterday

[#1]

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

[CELAMBARASAN · Accepted solution]

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

[#3]

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