Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

count for last 6 weeks

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

2 Replies
Not applicable

Use the follwoing script and Expression

let Last6Week=week(today())-6;

let TodayWeek=week(today());

count({<Week={">=$(=(Last6Week))<=$(=(TodayWeek))"}>}ID)

Not applicable

Use the follwoing script and Expression

let Last6Week=week(today())-6;

let TodayWeek=week(today());

count({<Week={">=$(=(Last6Week))<=$(=(TodayWeek))"}>}ID)