5 Replies Latest reply on Jul 12, 2017 4:24 PM by Sushant Jadhav

Not able to find number of occurrences across different measures.

Sushant Jadhav Jul 11, 2017 1:12 PM

Hello All,

I am trying to create a chart which has different measures like - QA Shelving Score, QA wall Scribe Score etc. which adds up to QA Overall Score. Now what i am trying to do is trying to get the number of times the score in any of the columns is not zero (Total Number of Records - No of times the score is zero.

I am trying to create a chart which shows the month on X Axis and within that month i want to show different types of scores and their counts (the ones which are not zero) on the Y axis.

I can do it for one measure (See screenshot for QA Exceptions Score). How do i do it for multiple measures? When i pull in all the measures in the chart they will tell me the counts of the records which do not have zero as there score. Also, i do not want an aggregate amount, i want the data score wise.

I have attached the Tableau Workbook with this and the sample data source in excel.

Regards,

Sushant Jadhav

data.xlsx 260.2 KB
Sample.twbx 246.1 KB

1. Re: Not able to find number of occurrences across different measures.

Amarendra Donthala Jul 11, 2017 1:23 PM (in response to Sushant Jadhav)

Hi Sushant,

If I had understood your question right, you can do it using measure names and measure values. Place measure name, measure values on columns and rows.
That should do it.

Amar
Like Show 0 Likes(0)

Actions
2. Re: Not able to find number of occurrences across different measures.

Sushant Jadhav Jul 11, 2017 1:55 PM (in response to Amarendra Donthala)

Hi Amrendra,

You completely understood my question.

There is a little tweak which i want. I want the month to be on the X Axis too. So that the graph can be split into parts (Months) where there is a count for each of the month. I know it will be a little messy but i just wanted to ask whether it is possible. The reason behind this thinking is it would be a little more easier to analyse the trend by the month if we have it this way.

Please let me know.
Like Show 0 Likes(0)

Actions
3. Re: Not able to find number of occurrences across different measures.

sunil.sachdeva Jul 11, 2017 5:22 PM (in response to Sushant Jadhav)

Hi,

convert month to continuous mark should get what you want.

Thanks,
Sunil
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Not able to find number of occurrences across different measures.

Amarendra Donthala Jul 12, 2017 5:54 AM (in response to Sushant Jadhav)

So, you can flip the axis and retain the months as dimension (or measure) which will give you a individual comparison by month. Something like the attached.

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
5. Re: Not able to find number of occurrences across different measures.

Sushant Jadhav Jul 12, 2017 4:24 PM (in response to Amarendra Donthala)

Thank you Amarendra and Sunil for your help with Tableau.

Sushant.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Not able to find number of occurrences across different measures.

1. Re: Not able to find number of occurrences across different measures.

2. Re: Not able to find number of occurrences across different measures.

3. Re: Not able to find number of occurrences across different measures.

4. Re: Not able to find number of occurrences across different measures.

5. Re: Not able to find number of occurrences across different measures.

Actions

More Like This