The report is a ‘Quality Dashboard’ which gives our partners (Meat packing establishments) certain metrics around their quality.
This is tracked by an Non Conformance Report (NCR) Rate = # NCRs/10MT Volume. Ideally we want to give each establishment a ranking against others, but they are competitors so this must stay anonymous. An example on PowerPoint is given below:
Trying to replicate this in QuickSight with live data has proved difficult. The main issue is that when I filter the dashboard to one establishment, the ranking breaks down as it filters out other establishments and essentially ranks the filtered establishment against itself. An example is attached in this email. I’ve tried creating a visual (graph attached) that assigns each establishment a reference number (to ensure anonymity) but I’m not sure how to then highlight the establishment in question, without filtering out all the other establishments.
The current red colour-coding is something I manually added but would be nice to do something similar that adjusts with a filter…
Hi @GeorgeQS ! Welcome to the community!!
There are two problems here; 1) selective filtering per visual and 2) custom coloring for bar charts.
The first problem is to prevent the sheet-wide filtering from affecting the ranked visual. You can deselect the ranked visual by going to the filter definition, selecting ‘This Sheet, All Visuals’ and enabling the ‘Custom select visuals’ button. Then you can simply deselect the ranked visual. See this in the screen shot.
The second problem is customizing the bar chart color based on a dynamic value. There’s nothing out of the box for this, but you get a sense of how to solve it from this post here. You’ll want to use a parameter and assign that value based on your user selection. Your calculated field (per the post) will then compare that value with the dimension in the bar chart which should bifurcate your data into ‘selected’ and ‘others’. Then drag this into the group/color well.
Hope this helps. Let me know how it works for you. If we need to dive deeper and iterate on the custom coloring we can create an Analysis in Arena.
Good luck
ws
