HI all,
I have a expresison , that shold show data of yesterday, so this is applicable fo rthis month , by defualt i'm showing latest month data on dashboard, so if i will change the filter to last month , it should show 'Na'
exression :
count({<NO={'Ba'},STATUS={'OPEN'},
Year={$(=max(Year))}
,[Calender MONTH]={$(=max([Calender MONTH]))},
[work_DATE] = {$(=Date(Max( {< NO={'Ba'}>} [workDATE])-1, 'DD/MM/YYYY'))SEQ_NO)
filter is : month year,