-
1. Re: Combo Chart off of a single measure - HELP!!??
Jim DehnerApr 21, 2017 1:36 PM (in response to Ryan Davis)
Hi Ryan
See if this is of any help - the spreadsheet is attached
What I did was duplicate your data source and only link it on Month (BTW - you may want to make that a real date in your data - its a string now)
Then I created separate charts - one from each source - (second image) by dragging the second source Monthly to the rows shelf
Then combined them with Dual Axis (right click the second pill and select dual axis)
Let me know if that helped
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
Combo Chart Help.twbx 903.1 KB
-
-
2. Re: Combo Chart off of a single measure - HELP!!??
Gerardo Varela Apr 21, 2017 2:42 PM (in response to Ryan Davis)Hi Ryan,
I took a shot at it and I'm really close. I'm just not sure how to remove the dates you have filtered out when having a continuous date on the columns tab. Hopefully the attached helps.
Regards,
Gerardo
-
Combo Chart Help234102gv.twbx 897.1 KB
-
-
3. Re: Combo Chart off of a single measure - HELP!!??
Ryan Davis Apr 21, 2017 5:04 PM (in response to Gerardo Varela)1 of 1 people found this helpfulAh, those dates dont matter, really. I can just exclude them from the data source. Thanks all for the help...I'll be taking a look this weekend.
-
4. Re: Combo Chart off of a single measure - HELP!!??
Zhouyi ZhangApr 21, 2017 5:27 PM (in response to Ryan Davis)
1 of 1 people found this helpful -
5. Re: Combo Chart off of a single measure - HELP!!??
Ryan Davis Apr 23, 2017 2:03 PM (in response to Gerardo Varela)1 of 1 people found this helpfulThis is exactly what I had in mind. Thank you!!! Mind explaining a bit what you did? I see the calc fields, so I can certainly copy that, but an explanation would help. I'm still fairly new at all this.
For the dates, our fiscal year begins in October, which is why I bring over the months as text and not a date. Just easier to manually sort than try and convert everything to date. For whatever reason Tableau hates our fiscal calendar.
-
6. Re: Combo Chart off of a single measure - HELP!!??
Gerardo Varela Apr 23, 2017 3:45 PM (in response to Ryan Davis)1 of 1 people found this helpfulI'll try! So I defined bar category and line category so I could split the monthly value by different dimensions. Then I changed your string month into an actual date so I could place it as a continuous field which is needed to draw lines across the window (I read somewhere in a future release this might be needed). .
Tableau by default will want to stack your bar graph by month. By tweaking the date start (months) with day offsets, 1, 5, 10 , then I can tell Tableau to plot the bar graph in slightly different day so it doesn't stack. After that it's just playing with the both axis so it look like the image you posted.
By the way ,Tableau does support fiscal years as shown below so I would pull the data as such and just let Tableau handle the fiscal year (I don't have to this in my work so there might be some nuances I'm aware of)
If this doesn't make sense let me know! I'll try to explain in more depth or point you some links that are more informative.
Regards,
Gerardo