Imitating Bar Chart Calculated Lines (Avg)

John-Paul_P
John-Paul_P ⚪️
edited February 26 in Card Building

Domo allows automatic calculation of some values on bar charts (Min, Max, and Avg). These values can be shown as "Calculated Lines" on a chart for comparison purposes. The great thing about these values are that they adjust based on chart filters. I would like imitate the Avg value and display it in a Single Value chart. I've attempted a Beast Mode calculated field that isn't returning a value and can't seem to get much closer than that. I've attached the current bar chart as reference to the Avg "Calculated Line" value that I am referring to as well as the current Beast Mode calculated field I am using. Any thoughts on how to snag this value? I haven't been able to use just a simple Average of a Measurement column because I want to display a dynamic average such as a monthly or weekly average and the rows aren't aggregated as such.

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!