Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking to use autoCalendar.YearMonth filter in an expression but it won't recognize 'Feb-2017'. It gives it in this format when i use it as a dimension in my charts.
Count(DISTINCT {<status={'Current'}, [RENDATE.autoCalendar.YearMonth] = {'Feb-2017'}>} ID) /
Count(DISTINCT {<[RENDATE.autoCalendar.YearMonth] = {'Feb-2017'}>} ID)
Anyone know the correct format?
Regards
Finbar
Convert your date in number i.e. NUM(Date) and use this numeric value in expression.
Using numeric value for date in expression is easier to use
Also does not work
There is something up with trying to reference the month... measure 1 and 2 do not work!
Pl Try
=Count(DISTINCT {<[RENDATE.autoCalendar.YearMonth] = {"$(=Date(MonthStart(Today()),'YYYY-MMM'))"}>} ID)
Hi all,
Found the solution! I was using single quotations, only works with double quotations!! Its always something easy!!
Count(DISTINCT {<status={'Current'}, [RENDATE.autoCalendar.YearMonth] = {"Feb-2017"}>} ID) /
Count(DISTINCT {<[RENDATE.autoCalendar.YearMonth] = {"Feb-2017"}>} ID)