Time series plot with Primary and Secondary axis

user05966
user05966 Member
in Charting

Hi,

 

I have below data;

DateCategoryValue
02-08-2019Cat110
02-08-2019Cat220
02-08-2019Cat330
03-08-2019Cat1110
03-08-2019Cat2-220
03-08-2019Cat3230
04-08-2019Cat130
04-08-2019Cat240
04-08-2019Cat340

 

With this data I want to create a time-series plot with below properties :

  1. Cat1 and Cat3 will be plotted with the Primary axis and  Cat2 will be with Secondary axis
  2. Cat1 and Cat3 will be line plot, whereas Cat3 will be Area plot
  3. Cat2 will be plotted with absolute value

Any pointer on how to create a plot with all above properties will be highly appreciated.

 

Comments

  • MichelleH
    MichelleH Coach

    I would suggest making separate beast mode calculations for each category. 

     

    Cat1:

    case when `Category` = 'Cat1' then `Value` end

     

    Cat2:

    case when `Category` = 'Cat2' then `Value` end

    Cat3:

    case when `Category` = 'Cat3' then abs(`Value`) end

    I don't believe there is a chart type that allows for both area and line plots in the same chart area. However, you should be able to include Cat1 and Cat3 on the primary axis of a Line + Grouped Bar chart by adding your Cat1, Cat3, and Cat2 calculations to the Y-axis & Series slots (in that order). Then under Chart Properties > General enter '2' in "Series on Left Scale"

     

  • user05966
    user05966 Member

    Your statement 'by adding your Cat1, Cat3, and Cat2 calculations to the Y-axis & Series slots (in that order). Then under Chart Properties > General enter '2' in "Series on Left Scale"' is not working at all.

     

    I cant generate line + bar chart, all I can see is single line.

     

    It is really bad that Area + bar chart is not possible in Domo

  • MichelleH
    MichelleH Coach

    Could you please share a screenshot of what you're seeing?

This discussion has been closed.

Categories