Overrides with Legend

Hello everybody,

I am working on a dashboard on which I am displaying multiple time-series graphs. For each graph I also want to display a single scalar value for each graph which is each dependent on a specific value in a database (so it has to be dynamic). Since it is not possible to define a dynamic alias value in SQL, I am currently performing a second query for this single value. I am displaying this value with the Values Property of The Legend options.

My problem is, that now every total values are shown. Thats why I want to override the legend only for the scalar values
=> I didn’t find the option to override the legend. Where do I find this option or is this not possible? (Why?)

Performing a second query is already a work-around for me. So if there is another possibility to add a scalar value (dynamic from a database) to each graph in a time-series any advice on how to achieve this would be appreciated.

My final legend should look something like this: [Graph_Name] [Scalar_Name]: [Scalar_value]

At the moment it looks like this:

I would also be fine with displaying two legends like in the image above. But I don’t want to have the Total: 24.7 for my graph (only for the scalars I need the total value)

Thanks in advance!