5 Replies Latest reply on Jul 17, 2018 12:08 AM by Mavis Liu

Hi All,

In Message Chart worksheet, parameters like % of messages viewed and hours to open don't add upto 100%. Rest parameters in the field add to 100%.

• 1. Re: Percentage doesn't add upto 100%

Hi Anish,

Unfortunately I am unable to use your workbook because you're using Tableau published data sources as your connection.

Please could you use only extracts and re-save as a twbx and attach.

Thanks,

Mavis

• 2. Re: Percentage doesn't add upto 100%

Hi Mavis,

Hope this will work, could you please check this one.

Thanks

• 3. Re: Percentage doesn't add upto 100%

Hi Anish,

Please can you clarify what the expected outcome should be and what the issue is? From what I can see, Carded and Hours to Open is using the MEDIAN value:

As the median for both carded and uncarded is 0.7833, and the overall median for both carded and no carded is 0.7833 that means it's 100%.

So what is your expected output?

Thanks,

Mavis

• 4. Re: Percentage doesn't add upto 100%

As you could see while choosing patrons:-

Carded : 54%

Uncarded: 46%

Total : 100%

but when we choose Hours to Open, each bar gives 100% (but the total should be 100%):

Carded: 100%

Uncarded: 100%

Total : 200%

When choosing % of messages viewed:

Carded: 96%

Uncarded: 105%

Total: 201%

The latter cases gives a total of more than 100%. Expected output should be 100% when we add both bars but it's increasing. Please help in fixing this issue.

• 5. Re: Percentage doesn't add upto 100%

Hi Anish,

I've updated your % of Promotions Viewed and I've now used the calculation called Promotions Sent Overall in the calculation:

This calculation works out the count of sent promotions for BOTH card and not carded. This LOD calculation excludes the chosen metric field and just does a general count overall.

So now for % of message it will show this:

However, with Hours to open, tableau is working it out as expected.

As the median for both carded and uncarded is 0.7833, and the overall median for both carded and no carded is 0.7833 that means it's 100%.

Because you're trying to do % of a total for median it does not work.

Thanks,

Mavis