hi there, I’m trying to create a bar chart with a reference line. each bar is the result of a table calculation field called AOV (this part is ok). for the reference line I wanted to use the total value of the AOV field. Its not a simple average, or median so I tried to use the custom value, but with no luck.
it there a way to use a variable in the custom value?
thanks in advance
There’s no way to reference a custom value like that in a reference line currently, but you could simulate the functionality with another table calculation. If you create a new table calc that references the ${view.AOV:total}, or whatever the correct field is in your case, you can visualize that as a new line in your viz.
It won’t have the special formatting & label that a reference line would, but it will still provide a visual frame of reference.
for the reference line I wanted to use the total value of the AOV field.
--This is what I want. And I use the pivot to show the bar with different colors. I would like this total average line is vertical, but I don’t know how to do it.