3 Replies Latest reply on Feb 2, 2018 8:09 AM by Jyothisree Rayagiri

Count of dimension without filters in tooltip

Gaurav Gupta Feb 2, 2018 6:17 AM

Hello Everyone,

In my chart, I am showing count of indexnum against week of dates. and Its working fine. There are 3 filters applied to it - pending flag = 'N' , Program code = 'ABC', source = 'XYZ'.

But in tool tip, I have to show count of indexnum. and this count should not get filtered by pending flag = 'N'. which means in tooltip it should show count of indexnum that gets filtered by Program code = 'ABC', source = 'XYZ' and includes all Pending flag.

Kindly help me on this.

Thanks.

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 ?
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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 ?
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Count of dimension without filters in tooltip

1. Re: Count of dimension without filters in tooltip

2. Re: Count of dimension without filters in tooltip

3. Re: Count of dimension without filters in tooltip

Actions

More Like This