I have list of metrics and their grade for different dimensions.
I need to determine the color of each metric by it's grade (each metric has different color scale)
since the grade changes based on dimension selections, I can't determine the color in the script, it has to be uppon user selection.
I created a stacked bar chart that will count the number of metrics for each grade.
I used aggr function in the chart which has poor performance (each selection can take up to 30 seconds), and I couldn't find another way to create the chart.
I attached a simple example (with no dimensions and minimum rows 😞
Each metric has Numerator, Denomionator, and it's grade is: Numerator\Denominator (for most metrics).
the forumula's are defined within the script, and I created a variable in the script for each metric to determine it's color.
Each metric has color scale: for example - metric 1 should be red if grade < 70, and Metric 2 should be red if grade is grade>30
