reference line using table calculation total

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

1 2 1,050
2 REPLIES 2

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. 

Top Labels in this Space
Top Solution Authors