Sorting? Legend? Filter Pane? Help!!

[jamiekim]

Hello!

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.

I appreciate your help ahead of time.

Thank You,

Jamie

[dwforest · Accepted solution]

You will probably want to use Set Analysis

https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

Basically, a measure with a filter for each of the 3 items. 

For over 100%, if [%Used] is the field containing usage, something like:

Count({<[Registration ID]={"=[%Used]>1"}>}[Registration ID])

[jamiekim]

It does sound like what I need from what I'm reading in the link you sent.  Let me try, I'll let you know! 

[jamiekim]

This solution worked!  Follow up question--

Is there any way to see all the individual data points rather than the totals?  I'm realizing the ability to peruse the individual data points would be helpful.  

Attached is a screenshot of the implementation of your solution.  I'm hoping to be able to click on or see all the individuals that have not used their mobile devices, for example.

Thank you, again!

[jamiekim]

I think I figured it out!  Added a table.