I want to render a Metric Visualization dynamically based on a dropdown filter control value. Metric value generation logic should change depending on the dropdown value.
Example scenario:
Filter dropdown field can have a value from ["daisy","rose","flower"]
Metric visualization logic is,
if (daisy) then calculate sum of daisy without sales
if (rose) then calculate sum of rose without sales
if (flower) calculate sum of all flowers with sales
Default dashboard filter should base on "sunflower". I want to change the metric value based on these conditions.