Please see attached bar chart. The chart shows mobile devices on the x-axis and percentage of minutes on mobile plan used on the y-axis. I am trying to easily show a few things--
1. The total number of devices that went over 100% of their plan minutes.
2. The total number of devices that used under 30% of their plan minutes.
3. The total number of devices that used none of their plan minutes.
I wasn't sure how to go about doing this. A filter pane? If so, what would the function/script look like? I tried a script in the filter pane, but it didn't work.
As you can see in the screenshot, I was able to color the bars according to the metrics above (red for above 100%, yellow for under 30%) and add reference lines, but I wasn't able to capture the totals, which is what I'm hoping to show somewhere.