Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody!
on x-axis as a dimension I use:
=Date(SetDateYear(Date, Year(Today())), 'DD.MM')
for measures I use set analysis - sum()- for current and previous year.
While switching to sheet I want to see only 25 last days. I tried doing it via sheet actions -> select values matching search criteria:
Field: Date
Criteria:
='>=' & addyears(date(Max({<gross_
AND >=' & date(Max({<gross_sales={*}>} Date)-25) &'<='& Max({<gross_sales={*}>} [Date])
However its not working (i can see all days starting from January) with AND condition I could only select last 25 days of this OR previous year. How to select last 25 days of both years?
try
If((DATEFIELD<(Today()) and DATEFIELD>(Today())-25),DATEFIELD)