5 Replies Latest reply on Sep 13, 2018 12:51 PM by Deepak Rai

# Percent of Total for Compliance Rates: Only show Y Percent

I'm trying to come up with compliance rates for my company on meeting a certain task with clients. They can either be compliant (Y), not compliant (N), or excluded (N/A). I'm able to get their 'compliance rate' to show up with a quick table calculation for percent of total by filtering out the N/As and comparing the Yes and the No, but then shows their yes percent and their no percent. I just want to show their yes percent. So, if we had 8/10 that met the measure, it would just show 80%.

It seems SO simple. It's literally A/A+B. I know I need to write a calculated field to achieve this, but it seems no matter what I try it doesn't work. Sometimes because I'm doing a string (since it's y,n) vs. integer, sometimes I can get a number to show up but it's completely inaccurate and I'm unclear what it's actually being calculated with.

I have a ton of dimensions and measures available. The key ones, I think, would be:

• Compliance (string, options are: Y, N, N/A)
• Client ID (whole numbers)
• Report Month (currently set as a string, Month, YYYY)

One quick note: because I have combined several months of data and several different measures in order to complete a more full dashboard there are also some nulls that might appear for a month as the client shows up one month and not another. I'm not sure this will impact it (currently they just filter out) but wanted to add in case.

Can anyone help with this seemingly basic question?

• ###### 1. Re: Percent of Total for Compliance Rates: Only show Y Percent

Do you have a workbook.May be with some fake data.

1 of 1 people found this helpful
• ###### 2. Re: Percent of Total for Compliance Rates: Only show Y Percent

Yes, attached here. This is extremely streamlined and has removed several of the columns of data that are included in this report.

• You'll note that there are sometimes two (or more) dates listed per month. This is because the client was contact more than once in the month so the system outputs all of the dates of attempted or completed contacts.
• More than just "were the calls completed" goes into the Compliance, but there are many factors that would impact that and the system automatically generates the y/n.

On sheet 1, what I would want to see is JUST the  Jan:100%, Feb: 60%, Mar: 80%, April: 100%, May: 100%, Jun: 75%, Jul: 80%. I don't need the percent that were out of compliance.

Hopefully that all makes sense, but let me know if not. Thank you! I've attached both the tableau with extract, as well as the original data source in case that's helpful.

One last thing: My tableau is one level down from the current so I'm unable to open files that are above 10.4. Our IT hasn't updated it yet and I don't have the permissions to do it myself, so if you're unable to send it in the 10.4 version just helping me figure out what the language for the calc field would need to be would be helpful.

Thank you!!

• ###### 3. Re: Percent of Total for Compliance Rates: Only show Y Percent

You need this Filter to Filter the view, but not data. So Here it is:

Thanks

Deepak

1 of 1 people found this helpful
• ###### 4. Re: Percent of Total for Compliance Rates: Only show Y Percent

Yes that did, thank you!

One quick question though -- if I wanted to do a dual axis with the raw numbers in the form of a bar chart behind it, is there a way to do that as a dual axis without filtering the N out of the bar chart portion?

• ###### 5. Re: Percent of Total for Compliance Rates: Only show Y Percent

Can you post that as a separate question after Closing this Thread as it will be difficult to say anything, till I see workbook which I always prefer..

Thanks

Deepak