
1. Re: Dual axis problemsone x axis is days, the other x axis is months. How to show them on a dual axis?
Deepthi Pullarkat Oct 9, 2014 10:03 PM (in response to Michael Sherman)Hi Michael,
Take a look at the attached workbook and let me know if this is what you are looking for.
Thanks,
Deepthi

Book2.twbx 1.3 MB


2. Re: Dual axis problemsone x axis is days, the other x axis is months. How to show them on a dual axis?
Radha Dorairajan Oct 10, 2014 3:24 AM (in response to Deepthi Pullarkat)1 of 1 people found this helpfulHi Michael,
if you have your parameter control and associated calculated fields in place, you just need to use the dual axis option and keep both the "day" aggregation and "month" aggregation as continuous. Screen shot attached. I hope this helps.
PS I have filtered the months to four months to reduce cluttering.

3. Re: Dual axis problemsone x axis is days, the other x axis is months. How to show them on a dual axis?
Michael Sherman Oct 10, 2014 6:53 AM (in response to Deepthi Pullarkat)Deepthi, thank you very much. This is not exactly what I was looking for but it is closethe big difference is that we would prefer if the bars were really each just a point, and that the points were connected by a line. I need a day or so to process all of this and look through it and I'll get back to you. Thank you!

4. Re: Dual axis problemsone x axis is days, the other x axis is months. How to show them on a dual axis?
Michael Sherman Oct 10, 2014 7:20 AM (in response to Radha Dorairajan)Radha, thank you. That worked very well for monthly total.
But what I would like to do is to change the line from monthly total to something else. Check this out:
The top graph is based on what you said, and it works perfectlydaily bars, line with monthly totals. The bottom graph is a moving average table calculation. What I would like to do is to take the line (months) from the moving average on the bottom and have a parameter (or some kind of dashboard control) that lets me replace the line on the top graph with the line from the bottom graph of moving average (or any other fieldlike running total by year, for example). Any ideas?
Thank you! 
5. Re: Dual axis problemsone x axis is days, the other x axis is months. How to show them on a dual axis?
Radha Dorairajan Oct 10, 2014 7:51 AM (in response to Michael Sherman)Hi Michael
Try the following solution
Create the required parameter containing the names of the calculations.
Then create a calculated field where you include an 'if' condition based on the parameter values
for example
if(<parameter value> = "moving average") then <table calculation function> else if ..... and so on and include this field on to your rows.
The thing to understand here is that , table calculations are also functions at the end of the day. You can find the list of table calc functions available in the link below.
Do reach out if there is anything .

6. Re: Dual axis problemsone x axis is days, the other x axis is months. How to show them on a dual axis?
Michael Sherman Oct 10, 2014 9:01 AM (in response to Radha Dorairajan)Thanks for your response Radha. I understood that aspect of the problemwriting the table functions out and creating a field with a CASE/IF statement that checks the value of a parameter.
The part I didn't understand was that Tableau was smart enough to change the "repeating every" part of the table calculation (which isn't part of the written calculation). So now I am able to switch between yearly running totals (repeating every year) and monthly running totals (repeating every month). That was my hangup and thank you for your answer. I should have had faith .
But there is still one more problem. Monthly totals (or yearly totals) look like this when using a table calculation while also showing the days (this is similar to what is in Deepthi Pullarkat answer workbook):Code is WINDOW_MAX(RUNNING_SUM(SUM([Amount])))
I want to replace these lines from the table calculation with a single point for each month joined together in a line graph (to look like what you posted first). I understand why the lines are showingTableau is doing the table calculation for every day, which results in a line. I can change the code to:
IF(index() = 15) THEN WINDOW_MAX(RUNNING_SUM(SUM([Amount]))) ELSE NULL END
Which gives:
What I am missing now is the ability to connect these lines. I know if I follow your first answer I can get this as lines, but then I lose the ability to do Table calculations like running totals and moving averages.
Any thoughts on this?
Thank you so much Radha!