6 Replies Latest reply on Oct 18, 2017 1:50 PM by David Switzer

Need help to convert the Continuous Measure to measure

Naveen B Mar 17, 2017 9:46 PM

I have created a calculated field usig measures, the calculation is as expected, but I want to use show column grand total option in Analysis tab.

when I select Totals-> show column grand totals.

the Grand Total row appers but the fields are blank.

the calculation image is attached

For example: X is the calculated field, when i drag it to marks, the measures option in X is grayed out, is this the reason for not showing up the column total? if so please help me how to get the grand totals of such calculated field Continuous Measure.

Thanks

Naveen

sample.twbx 10.1 KB
tableau.PNG 22.4 KB

1. Re: Need help to convert the Continuous Measure to measure

Walt Reed Mar 17, 2017 7:18 AM (in response to Naveen B)

Hi Naveen,
Is it possible for you to attach a packaged workbook? It's hard to answer your question without being able to work with your day
Like Show 0 Likes(0)

Actions
2. Re: Need help to convert the Continuous Measure to measure

Naveen B Mar 17, 2017 10:23 PM (in response to Walt Reed)

Hey, i have attached the sample packaged workbook.

In the workbook Grand totals are displaying as value 0, where i want the sum of the values.

Thanks in advance
Like Show 0 Likes(0)

Actions
3. Re: Need help to convert the Continuous Measure to measure

Naveen B Mar 20, 2017 2:46 AM (in response to Naveen B)

Hello ,

Can someone try to help me on the above question?

Thanks
Naveen
Like Show 0 Likes(0)

Actions
4. Re: Need help to convert the Continuous Measure to measure

Walt Reed Mar 20, 2017 7:05 AM (in response to Naveen B)

Hi Naveen,
I've taken a look at your workbook, but I can't quite figure out what you're wanting to total up. From what I see, you're calculating a % of total calculation based on COUNT(Appid):
Then, the next calculation (which you're trying to do a grand total of) is the % difference of the previous calculation? If that's the case, then what does your desired output look like?

Walt
Like Show 0 Likes(0)

Actions
5. Re: Need help to convert the Continuous Measure to measure

Naveen B Mar 20, 2017 8:53 AM (in response to Walt Reed)

Hey, thanks for looking in to this.

This is actually for calculating shift change(psi).

in the sample workbook which i have attached, the grand total should be the sum of the values like in the image below

so, my calculated values are absolutely correct, its just that the Grand total should display the sum of the columns.

thanks
naveen
+91 9916290906
Like Show 0 Likes(0)

Actions
6. Re: Need help to convert the Continuous Measure to measure

David Switzer Oct 18, 2017 1:50 PM (in response to Naveen B)

Naveen - I am trying to calculate PSI too - were you able to solve this?
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

Need help to convert the Continuous Measure to measure

1. Re: Need help to convert the Continuous Measure to measure

2. Re: Need help to convert the Continuous Measure to measure

3. Re: Need help to convert the Continuous Measure to measure

4. Re: Need help to convert the Continuous Measure to measure

5. Re: Need help to convert the Continuous Measure to measure

6. Re: Need help to convert the Continuous Measure to measure

Actions

More Like This