1 Reply Latest reply on Aug 3, 2018 7:36 PM by swaroop.gantela

    Different dates same axis and action filters

    Matthew Yandell-Thomas

      Hi all,


      I'm still trying to get to grips with Tableau and I would appreciate some help please. I am trying to make an interactive map using vectors and tabular data with a time element. I would like to plot the values of two tables on the same graph. However, one table contains a monthly average whereas the other has exact dates. Both datasets do cover the same time period and all values are between 0 and 1.


      Here's an example of what I am trying to achieve


      This image shows my vectors. When I click on a polygon a graph will appear showing a time series as below:


      (Please ignore the different date range in this example. I know have new data covering the same time period)


      I originally had two separate graphs and you could click multiple polygons to compare results. I achieved this by dropping the polygon ID field into the colour slot



      I have received a request to combine both plots onto a single graph but I'm struggling to get them to plot accurately (I think this would look horrible when selecting multiple polygons, but I would like to do it to show my manager how bad it would look).


      Here's an extract of the date fields I'm working with as an example:






      And here's my first dual axis plot:


      And if I set the date to exact date the plot changes to this:


      It's also summing the values for each individual polygon which is something I don't want to happen.


      Whereas what I'm trying to achieve is something like this:




      Any help would be greatly appreciated.


      Apologies if I haven't explained myself quite so clearly. I'm rushing this morning!





        • 1. Re: Different dates same axis and action filters



          I'm not sure that I quite caught the gist, but please see if the below could give ideas.


          I joined my daily and monthly tables on region alone.

          Then to filter out unneeded combinations, I made of filter of:



          Then I plotted the two vaules using the MeasureName/MeasureValue method

          and got them all to plot together and continuously.


          Please see workbook v10.3 attached in the Forum Thread.


          If this does not replicate your scenario,

          please adjust the attached workbook and spreadsheet to more closely match yours.