Time series plot with Primary and Secondary axis

Reply
Yellow Belt

Time series plot with Primary and Secondary axis

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.

 

White Belt

Re: Time series plot with Primary and Secondary axis

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"

 

Highlighted
Yellow Belt

Re: Time series plot with Primary and Secondary axis

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

White Belt

Re: Time series plot with Primary and Secondary axis

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


Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!