Add ability to color a Line Chart with multiple metrics in the vertical axis
I have a simple report that includes data for multiple regions with a metric value (see screenshots). This report includes 2 columns for targets (yellow threshold and red threshold). I would like to include the multiple regions as shown in screenshot 2 AND the target lines defined in the threshold columns, but none of the line chart options (line, combination) allow me to bring in the threshold series with the primary metric series because there are multiple regions (where region is used as the color in the chart to display multiple regions).
I see the ability to add reference lines with a hardcoded value, but the values for the targets need to be dynamic because they are calculated based on the data in the source table, so this does not work.
This is a very common use case to display targets on a chart along with data for more than one dimension series so I have to assume this is somehow possible in Yellowfin so if anyone can provide guidance on how I can set this up I would appreciate it.
If this is not possible, I would request that reference line values allow for binding to a column value in the report be added in a future release.