I have a chart showing support minutes per event size. The expression column header also has a total, and I want to provide the percentage of the total related to each entry. I haven't been able to get this to work, and I would appreciate any suggestions from this group.
For example, my data chart looks like this:
Event Size
Support Minutes
Small
1000
Medium
3000
Large
2000
The Support Minutes header totals 6000. I want to create an additional column that shows 16.6%, 50%, and 33.3% respectively.
Here are the issues I have encountered:
I have to add a specific Interval Format (mm) to get the time to calculate and show and calculate minutes properly. However, the Interval format option does not allow the "Show in Percent (%)" option. The format settings which do allow "Show in Percent (%)" format the data incorrectly.
The values involved in creating the "minutes" entries require set analysis as well as the results of individual selections
Here's what I have tried:
Creating a variable varSupportTime = SUM({$<Type={'Webcasts'}>}Duration) this one results in a value of mm2e+002, so not helpful.
I've tried adding the NUM function NUM(SUM({$<Type={'Webcasts'}>}Duration),'mm') to force the formatting, but this didn't work.
The variable, if built correctly, could be used to divide the Support Minutes and generate a percentage.
An additional issue with my variable is that it does not change with additional selections. For example, right now it totals the entire data set. If I want to select a specific month, week, location, etc, I would want the sum to follow.
What do I need to do to get a percentage column which shows the value in the Support Minutes column divided by the total of that column, while at the same time maintaining the number format (mm)? Thanks in advance.
