Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Please advise , I have to design a report by defaulting the table to show only last 30days of data from today
I have a table invoiceid,amountdue,invoicedt,org . I have created variable vlast30days==date((today()-30),'MM/DD/YYYY')
I have applied set analysis on the column amount due
=sum({$<org={'x'},[invoicedt]={">=$(vlast30days)"}>}[amountdue])
the table works fine by filtering data to show only last 30days.
However when i click on the invoicedt column it shows all the records from the data set irrespective of last 30days how do i limit this invoice dt to column to show last 30days. it seems all other columns are also showing in the same way when i click on search (magnifier) icon
I created some mockup data and tried to reproduce your issue. See screnshot and attached qvf.
For the dimension I used the following expression:
=if(invoicedt>='$(=vlast30days)',invoicedt)
please try:
=sum({$<org={'x'},[invoicedt]={">=$(vlast30days)"},[invoicedt]>}[amountdue])
I created some mockup data and tried to reproduce your issue. See screnshot and attached qvf.
For the dimension I used the following expression:
=if(invoicedt>='$(=vlast30days)',invoicedt)