Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
I want to show last 6 weeks values in my graph
My date dimension is =day(weekstart(Created))&'-' & day(weekend(Created)) &' ' & monthname(Created)
and my expression is =count(ID)
Thanks
Use the follwoing script and Expression
let Last6Week=week(today())-6;
let TodayWeek=week(today());
count({<Week={">=$(=(Last6Week))<=$(=(TodayWeek))"}>}ID)
Use the follwoing script and Expression
let Last6Week=week(today())-6;
let TodayWeek=week(today());
count({<Week={">=$(=(Last6Week))<=$(=(TodayWeek))"}>}ID)