I am trying to calculate sum of last 7 days of data.
It works fine when I try the following formulas with sample-superstore data, however, I see three dots in each cell when I perform similar calculations connecting to an extract ( data source: SQL server)
Last 7: DATEDIFF('day',ATTR([Order Date]), TOTAL(MAX([Order Date])))<7
Last 7 days Sales: IF FIRST()==0 THEN WINDOW_SUM(IIF([Last 7], SUM([Sales]), NULL)) ELSE NULL END
Any suggestions please?
The issue is resolved by using the below formula and moving the date pill from details to columns shelf
Last 7 days Sales: WINDOW_SUM(IIF([Last 7], SUM([Sales]), NULL))