Trying to Ignore Values from 2 Calendar Selectors that always have one selected in Set Analysis
Hi all,
i'm having what seems to be a simple issue (driving me mad) - i need to ignore two selectors that are set to always one selected (year and month).
tried the usual, %mancl_month=, %mancl_year =
but its not working.
the chart in question has 2 expressions, the first is calendar driven where there is always a year and month selected (2 selection boxes), the 2nd daily expression needs to ignore the calendar objects (month and year) and display data as of today (man_month_point_indicator={'3'}). but if i select a year/month for the 1st calendar driven expression, and then select the expression that needs to ignore the calendar selctors and display data as of today, the expression will not ignore the calendar selections.
=count({< man_month_point_indicator={'3'}, // this is today in the data set %mancl_month =, // ignore month selection box from 1st expression %mancl_yea r= // ignore year selection box from 1st expression >}man_assignment_no)
