-
1. Re: Create a Scatter Plot with different filters for X and Y Axis
Joshua Milligan Nov 15, 2013 2:26 PM (in response to Darin Friedrichs)Darin,
You can use parameters to drive a couple of calculated measures for the plot. I've attached a workbook here to demonstrate. The first tab is the simple setup, the second tab "synchronizes" the axes using hidden reference lines (see http://community.tableau.com/message/236674) so that you can make accurate comparisons.
Note that the parameters can be initialized with values from the country field, but are not dynamically updated with values from that field.
Regards,
Joshua
-
Filter for XY.twbx 642.3 KB
-
-
2. Re: Create a Scatter Plot with different filters for X and Y Axis
Joshua Kennedy Nov 15, 2013 2:20 PM (in response to Joshua Milligan)1 of 1 people found this helpfulAlso don't forget to add Month to detail or pages so you can see the Monthly Average Sales.
-
3. Re: Create a Scatter Plot with different filters for X and Y Axis
Joshua Milligan Nov 15, 2013 2:27 PM (in response to Joshua Kennedy)Good catch!
-
4. Re: Create a Scatter Plot with different filters for X and Y Axis
Joshua Milligan Nov 15, 2013 2:28 PM (in response to Joshua Kennedy)Actually, a very good catch as it made me realize I needed to adjust the country average calculations to return 0 instead of NULL. Otherwise, marks were not showing up when one country didn't have sales in a given month. Thanks!
I've updated the workbook and screenshot in the original reply.
Regards,
Joshua
-
5. Re: Create a Scatter Plot with different filters for X and Y Axis
Joshua Kennedy Nov 15, 2013 2:31 PM (in response to Joshua Milligan)No problem and well done.
-
6. Re: Create a Scatter Plot with different filters for X and Y Axis
Darin Friedrichs Nov 19, 2013 2:12 PM (in response to Joshua Milligan)Awesome, thanks guys! Works great
-
7. Re: Create a Scatter Plot with different filters for X and Y Axis
Joshua Milligan Nov 19, 2013 2:16 PM (in response to Darin Friedrichs)You're welcome!