6 Replies Latest reply on Oct 21, 2016 12:22 AM by Archana N

Multiple series in single chart with multiple time dimension values(X-axis)

Hi I am trying to achieve - 3 line series in a single graph.

Series 1: sum(amount) group by months

Series 2: sum(amount) group by Quarter

Series 3: sum(amount) group by Year

I want all the 3 series or 3 line charts to be in single sheet with common X-axis - showing M1,M2,M3,..M12; below M1,M2,M3 - Q1,below M4,M5,M6 - Q2 and so on..below Q1,Q2,Q3,Q4  - should show Y1 (if multiple years are there - should show accordingly - Y2,Y3,etc)

How do I achieve it in Tableau?

• 1. Re: Multiple series in single chart with multiple time dimension values(X-axis)

Hi ,

Tried something like below chart with dual axis and LOD expressions for Measure value. Is this what you require.

Green line is Year wise , Orange line is Quarter wise 1 is Q1, 2 is Q2, 3 is Q3, 4 is Q4. and Blue line is Month wise.

1 of 1 people found this helpful
• 2. Re: Multiple series in single chart with multiple time dimension values(X-axis)

First you should calculate your measures based on the time frame. Once done then you can do something like this

Drag Measure Names from dimension pane in filters shelf and filter only required measures. In your case you should select Series1, 2,3..! Then drag measure values to rows shelf and your month field to columns shelf. Finally using Ctr and drag measure names on color marks card.

Hope this help.

Mahfooj

• 3. Re: Multiple series in single chart with multiple time dimension values(X-axis)

Hi Archana,

to my knowledge with 3 dimensions on x-axis, not possible to have a continuous line chart.

Thanks,

Sreekanth.

• 4. Re: Multiple series in single chart with multiple time dimension values(X-axis)

Hi,

Thanks for your response.I am looking something like you have explained.

Same measure t get aggregated at 3 different levels (@month - 1 line series,@Quarter-another line and @year level-another line series)

I need it like its continuous.

PFA - I have attached for only amount aggregated at month level ; similarly i need for Quarter and Year level too.

• 5. Re: Multiple series in single chart with multiple time dimension values(X-axis)

Hi Archana,

Yes we can do it, Attaching workbook for your reference.

1 of 1 people found this helpful
• 6. Re: Multiple series in single chart with multiple time dimension values(X-axis)

For some reason - I couldn't open your attachment - but I recreated as you had told above in your message and got the expected output. Thanks a lot.