Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
quick question, do you have any idea about the syntax error in my analysis set?
I can't find my error on this line.
Thank you in advance.
=count({<if_statut_equip_={'OK'}+<if_statut_equip_={'OK_SDM'},[date.autoCalendar.Date]={">=$(=MonthStart(max([date.autoCalendar.Date]),-12))"}*{"<=$(=MonthEnd([date.autoCalendar.Date]))"}>} distinct (equipement))/Count({<service_responsable=,[date.autoCalendar.Date]={">=$(=MonthStart(max([date.autoCalendar.Date]),-12))"}*{"<=$(=MonthEnd([date.autoCalendar.Date]))"}>} total distinct([equipement]))
I think your applied operators between the various set-parts are causing the error respectively unwanted results:
count({<if_statut_equip_={'OK'}+<if_statut_equip_={'OK_SDM'},[date.autoCalendar.Date]={">=$(=MonthStart(max([date.autoCalendar.Date]),-12))"}*{"<=$(=MonthEnd([date.autoCalendar.Date]))"}>} distinct (equipement))
Instead of the above try it with:
count({<if_statut_equip_={'OK', 'OK_SDM'},[date.autoCalendar.Date]={">=$(=MonthStart(max([date.autoCalendar.Date]),-12))<=$(=MonthEnd([date.autoCalendar.Date]))"}>} distinct (equipement))