KPI need to interact with pivot table

Question & Answer
, , , , , , ,
1

HI all
i have 20 kpis and one pivot table with all the data when ever clicks on kpi need to show that data in pivot table and need button to call back action

2

Hello @vijay_1432 welcome to the QuickSight community!

You can use custom actions on your KPIs to filter your pivot table.

To create a “Reset” button, you just need to format down a table and use a navigation action on the same sheet to reset all your parameters to default values.

3

Hi @duncan I have 20 KPIs created using calculated fields. In my pivot table, I want to create an interactive experience where, when I click on a single KPI, the related data is displayed dynamically. For example, a KPI might reflect multiple scenarios—like Region = US, Age = 55–65, and Error Code = 25.

I want this functionality to work like a conversational drill-down (similar to a chat), where selecting a KPI filters and updates the visual based on those conditions. I noticed that in “Actions”, there’s an option called Select Field. I’d like to use this to create an interactive KPI visual—so that when a user drags and drops a field into the KPI tile, it automatically updates values based on selected filters like Region, Age Group, and Error Code.

Essentially, I’m trying to implement a slicing and dicing functionality. How can I achieve this? If possible, please create a sample scenario in Arena or similar to help illustrate it.

4

Hi @duncan let mw know the possibilities

5

Hello @vijay_1432

The custom actions work by pushing values from parameters and fields, not by moving or adding fields to visuals. Essentially what you are describing is not something QuickSight can do natively.

You could create a calculated field that would show fields dynamically based on user selection of a KPI. To set that up you would create a set of parameters to capture the selection from the KPI, so ${Dimension1} or ${Value} for example. Then in a calculated field you would create conditional logic to pass the fields chosen by the user to your pivot table field wells:

Dimension Calc:

Ifelse(
${Dimension1} = [DimensionFieldA], {DimensionFieldA}
etc....,
NULL
)

You would then do the same for your Values. Then apply this to your dynamic pivot table. The other option is creating a custom solution that you use in an embedded environment.