Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I want to display only the data for the past 10 weeks in a graph : 9 full weeks + the week that has begun.
cal_date_num is the date in numeric format (eg. 40755).
In my set analysis, I put :
=sum({< cal_date_num = {>= max(cal_date_num)-63-num(weekday(max(cal_date_num))+1} >} [Compteur_appels] )
63 = 7x9
=1 because num(weekday) goes from 0 to 6.
This formula doesn't work, the error is "Error in set modifier ad hoc element list".
What can I do ?
Thank you for your help
Have a good day
Try:
=sum({< cal_date_num = { ">= $(=max(cal_date_num)-63-num(weekday(max(cal_date_num))+1) "} >} [Compteur_appels] )
Try:
=sum({< cal_date_num = { ">= $(=max(cal_date_num)-63-num(weekday(max(cal_date_num))+1) "} >} [Compteur_appels] )