Secondary Y Axis

user02428
user02428 Member
in Charting

Wondering if there's a way to create a secondary Y Axis? In Excel you can do this on a combo chart in order to show multiple metrics on one graph. Additionally is the only way to layer a line over bar with the YoY graphs?

Best Answer

  • PodiumMason
    PodiumMason Contributor
    Answer ✓

    Hey @user02428,

     

    Out of the box Domo will allow you to combine metrics with different types on the same graph. YFrom your example, you could put both total impressions and average CTR metrics on a grouped bar and line or multi line graph and Domo will create a secondary axis based on the datatypes of the different metrics. The first series listed will be the left axis and the second metric will be the right axis. 

     

    Screenshot below:

    2018-04-17_14h07_32.png

     

    Let me know if this is helpful. 

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • Unknown
    Unknown

    Please take a look at the following post/solution and let me know if this answers your question:

     

    https://dojo.domo.com/t5/Card-Building/Is-there-a-way-to-replicate-an-Excel-combo-chart-in-Domo/m-p/6049

  • user02428
    user02428 Member

    So that solution would allow you to only show one metric across the time and broken up by the series. I'm wondering if there's a way to show multiple metrics such as sum of impressions and average CTR? This would require a secondary axis because they would have two different calculations and would be two different number types.

  • PodiumMason
    PodiumMason Contributor
    Answer ✓

    Hey @user02428,

     

    Out of the box Domo will allow you to combine metrics with different types on the same graph. YFrom your example, you could put both total impressions and average CTR metrics on a grouped bar and line or multi line graph and Domo will create a secondary axis based on the datatypes of the different metrics. The first series listed will be the left axis and the second metric will be the right axis. 

     

    Screenshot below:

    2018-04-17_14h07_32.png

     

    Let me know if this is helpful. 

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • user09913
    user09913 Member
    @user02428 wrote:

    So that solution would allow you to only show one metric across the time and broken up by the series. I'm wondering if there's a way to show multiple metrics such as sum of impressions and average CTR? This would require a secondary axis because they would have two different calculations and would be two different number types.

    Was this resolved? I'm curious and trying to do this as well.

    Thank you!

  • user08240
    user08240 Member

    I agree - I don't think this answers my question. 

     

    I have the following data:

     

    week_beginning, active_people_this_week (1),active_people_last_4_weeks (2), =(1)/(2) (calculated filed)

     

    I want (1) & (2) to be on the left y axis, and the =(1)/(2) (calculated filed) to be on the right axis. How do I do this step by step?

     

    Thanks!

  • user08240
    user08240 Member

    What Domo is doing (attached)

This discussion has been closed.

Categories