Okay, so I have a really simple but confusing question.
I have this chart which shows the percentage of tickets that are late and on time by the User Role. The problem is, I only want to show the "OnTime" percentages and remove the "Late" category from the x-axis. I'm having trouble because my percentages are calculated as "% of parent Column total," so if I filter out the "Late" tickets, my percentages do not work correctly.
Any ideas as to how to remove the Late data points on the graph without messing up the percentages?
[/IMG]
I have this chart which shows the percentage of tickets that are late and on time by the User Role. The problem is, I only want to show the "OnTime" percentages and remove the "Late" category from the x-axis. I'm having trouble because my percentages are calculated as "% of parent Column total," so if I filter out the "Late" tickets, my percentages do not work correctly.
Any ideas as to how to remove the Late data points on the graph without messing up the percentages?
