Im confused. What happened to my dashboard? For example, in the workbook I uploaded, the % SLA for june 2017 is 38%. In the workbook you attached, it says 83%.
Why did those values change?
The only calculation I need to change is the "% Happy", to exclude "ticket ID" = blank.
I just need one chart which shows 3 lines for %SLA, %FCR and %Happy, but it needs to be all in one chart like on the sheet 9 of the workbook I uploaded.
and for % Happy, it needs to be calculated so it excludes the blank ticket ID.
Perhaps this will help, take a look at the attached excel file. I have filtered date completed (column F) to show only August. Column AG is excluding blanks. Column AB shows 24 satisfaction entries, 23 of which are "Happy" so 23/24 = 96% happy.
So on my sheet 9 for month of August 2017 on the line chart, % happy = 96%. But right now it shows 0%
Even when I remove total from the formula like you said, it still didnt give me the 96% happy on my sheet 9 in my workbook.
Ok, so when I add the filter for satisfaction = null. It effects the other values (SLA and FCR).
Is there a way to make the line chart for "happy" ONLY, exclude "null" without it effecting SLA and FCR?
Because SLA and FCR came from a separate workbook. I combined ticket satisfaction with that workbook in Tableau. In the workbook attached here in this post, on sheet 9, the line charts for SLA and FCR are correct. I don't want those to change.
Now for % Happy, I need to calculate % of total happy, but exclude ticket ID = null. Is there calculation we can write just for that and use that, so I don't have to use a filter? because using the filter messes up the values for SLA and FCR.
Yes! That's it. Thank you so much for all your help and patience.
Glad to help you.