Average for Multi Line Line Graph

What is the best way to add an Average line to Multi Line LIne Graph?   Some cards do this automatically, wondering how to format the data, card properties to get the Average line to appear. 

Best Answer

  • KurtF
    KurtF Domo Employee
    Answer ✓

    I'm assuming you have a series selected. You could probably create a BeastMode for each of the series members and then create one that contains the average. I think it would look something like this:

     

    Brand A

    SUM(CASE WHEN `Dimension` = 'Brand A' THEN `Metric Total` ELSE 0 END)

     

    Brand B

    SUM(CASE WHEN `Dimension` = 'Brand B' THEN `Metric Total` ELSE 0 END)

     

    Avg of All Brands

    AVG(`Metric Total)

     

    Let me know if this makes sense.

    KurtF
    **Say “Thanks” by clicking the “heart” in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • KurtF
    KurtF Domo Employee
    Answer ✓

    I'm assuming you have a series selected. You could probably create a BeastMode for each of the series members and then create one that contains the average. I think it would look something like this:

     

    Brand A

    SUM(CASE WHEN `Dimension` = 'Brand A' THEN `Metric Total` ELSE 0 END)

     

    Brand B

    SUM(CASE WHEN `Dimension` = 'Brand B' THEN `Metric Total` ELSE 0 END)

     

    Avg of All Brands

    AVG(`Metric Total)

     

    Let me know if this makes sense.

    KurtF
    **Say “Thanks” by clicking the “heart” in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Was able to get it to work by doing the following. 

    Build beast mode calculation per each line using case

    Example

    CASE
    When `Event` LIKE '%In' then 1 else 0 end

     

    Created Beast mode to do the difference between in, out to get a net. 

     

    Switched from Multiline to single line and added each beast mode to the series section so could display in, out and net on the same graph. 

     

    Thanks Kurt!

     

This discussion has been closed.