Time series plot with Primary and Secondary axis

user05966

Hi,

 

I have below data;

Date	Category	Value
02-08-2019	Cat1	10
02-08-2019	Cat2	20
02-08-2019	Cat3	30
03-08-2019	Cat1	110
03-08-2019	Cat2	-220
03-08-2019	Cat3	230
04-08-2019	Cat1	30
04-08-2019	Cat2	40
04-08-2019	Cat3	40

 

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.

 

MichelleH

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

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

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

---