This content has been marked as final.
Show 3 replies
-
1. Re: Count of dimension without filters in tooltip
Jyothisree Rayagiri Feb 2, 2018 7:09 AM (in response to Gaurav Gupta)You can write a Fixed LOD with an if statement to mark the pendings.
Can you share your workbook ?
-
2. Re: Count of dimension without filters in tooltip
Gaurav Gupta Feb 2, 2018 7:49 AM (in response to Jyothisree Rayagiri)Wrote this- {FIXED DATEPART('week',[DATES]),[CAL_PROGRAM_CODE],[SOURCE]: COUNTD([INDEXNUM])}
not giving right count.
-
3. Re: Count of dimension without filters in tooltip
Jyothisree Rayagiri Feb 2, 2018 8:09 AM (in response to Gaurav Gupta)Should be something like
{FIXED DATEPART('week',[DATES]),[CAL_PROGRAM_CODE],[SOURCE]: COUNTD( if Pending='N' then [INDEXNUM]) else 0 end }
Can't really give you a final calc without looking at the data.
Is the Indexnum measure in your data or a table calc ?