KPI Visual Split by Dynamic Attribute Values in QuickSight

Q&A
, , , ,
1

Hi everyone,

We’re currently facing a challenge in Amazon QuickSight and would appreciate any guidance or suggestions.

We’re trying to create KPI visualizations that are split by the values of a specific attribute — in our case, Status. The values under Status (e.g., Approved, Rejected, Declined, etc.) are not predefined and can vary depending on configuration. This means we don’t know in advance what the values will be, and therefore we cannot create static filters or individual KPI visuals for each value.

Our goal is to dynamically generate KPI visuals for each unique value under the Status attribute, without hardcoding or manually filtering them. Is there a way to achieve this in QuickSight — perhaps using parameters, calculated fields, or another approach?

Any help or ideas would be greatly appreciated!

Thanks in advance,
Elitsa

2

Hi @eandreeva,

I think this is something you might be able to achieve with HighCharts in Quick. If you use a bullet chart in HighCharts you can visualize as many KPIs that can be pulled from the data and you can also dynamically label them in the chart. If you go to this blog post ( Create custom charts in Amazon QuickSight using the Highcharts visual | AWS Business Intelligence Blog ) you’ll see an example towards the bottom outlining how to build a highchart with Bullet Charts.

In this example there’s only one region in the output. But if there were multiple regions you would get a Bullet Graph for each region. You can then dynamically populate the X-Axis with the region name using code like the following:

  "xAxis": {

    "categories": ["getColumn", 0]

  }

This will populate the X Axis dynamically with the region name in this case since that’s column 0 in our dataset. For your use-case each unique Status attribute you have will be its own labeled Bullet Chart along with the current value/target value for the KPI.

Hopefully this helps answer the question.