How to show multiple selected metrics in a pivot table (using multi-select parameter)?

Q&A
, ,
1

I have a calculated field like this:

ifelse(
  in('Capacity WoW Changes', ${MetricDevMultiple}), capacity,
  in('Volume WoW Changes', ${MetricDevMultiple}), volume,
  ...
  '999'
)

MetricDevMultiple is a multi-select parameter (around 20 metrics).

Pivot table setup:

  • Rows: site

  • Columns: date

  • Values: metrics (calculated field above)

Problem:
When I select multiple metrics in the parameter, the pivot table only shows one metric at a time.

Question:
Is there a way to display multiple selected metrics at once in the pivot table (without pivoting the dataset outside Quick Sight)?

2

Hello @leabt , welcome to the Quick Sight community!

Currently it is not possible to show multiple metrics dynamically in a pivot table. I can mark this as a feature request for the Quick Sight team.

You would need to add each of those metrics to the value field well to show them.

3

Thank you for the clarification! I’ll add the metrics manually for now. A dynamic option would definitely be valuable for flexibility, so marking it as a feature request would be appreciated.

1 Like