1 Reply Latest reply: Jun 20, 2014 8:48 AM by Tresesco B RSS

    Error in set modifier ad hoc element list

      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