KPI Visual Split by Dynamic Attribute Values in QuickSight

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.