The last month with data isn't the current calendar month (payroll for instance).The out of the box feature of Sisense supports only the last calendar month
Below shows a solution to have a default filter that shows the most updated month with data.
SELECT MonthKey, rankdesc(MonthKey) MonthsOrder
(SELECT DISTINCT MonthKey FROM [fact1] ) m
(SELECT Date,100*getyear(Date)+getmonth(Date) monthkey
FROM [Date Dimension.csv]
WHERE Date > createdate(2008,1,1)) dc --restricts only dates since 2008
JOIN [Months_Order] mo ON mo.MonthKey=dc.MonthKey
Report Community Bug
Recommend Community Enhancement
Request Community Content
Earn a BETA Launch Challenge Badge!
Recommended quick links to assist you in optimizing your community experience:
Need additional support?:
Community Support Request