Hi, I was wondering if there is a way I could do one multi-select filter for the whole sheet which could
(1) have a limitation of choosing at max 5 KPIs from a range of metrics (for instance - different rates) in the multi select filter
AND
(2) as I choose the 5 KPIs from that one multi-select filter, assuming I have 5 empty scatter plots on the pane, and all of the plots are the same x value which is date but the y value will be the value derived by those KPIs defined from the filter
Ex. Imagine 5 empty scatter plots, date as my x axis, one multi select filter for rates such as (production rate, sales growth rate, cost growth rate, profit growth rate, and one more rate that is picked from the multi select filter) from a range of 90 different KPI metrics; I would ideally want as I pick those metrics, they get populated individually at each plot.
Plot 1, Date on production growth rate
Plot 2, Date on Sales Growth Rate
Plot 3, Date on Cost Growth Rate
Etc.
These 5 rates are picked out from a range of 90 different KPI metrics, and they get individually plotted on each scatter plot in our case 5 visuals.
Could this be done on Amazon Quicksight?