Skip to main content

I would like to have an interactive plot that changes by selecting a value from a filter. I would like to have two lines for comparison that are independent of the filter. I can create a sheet with the interactive filter and I can add a sheet with the two lines for comparison but I'm having a difficult time incorporating the two.

 

Here are the specific details:

 

I have a dataset with 3 columns -> User Name, Event Date and Value (this is binary).

User Name can have null values. I created a calculated variable called Person Group that separates User Name into a "valid user" and "Null user".

plot 1 -  MONTH(Event Date) as Columns, AVG(value) as Rows with the Person Group on the color mark. This is the plot that is independent of the filter. I would like these two lines to be my comparison lines.

plot 2 - MONTH(Event Date) as Columns, AVG(value) as Rows with the User Name as a filter. This changes as I select the filter.

 

In order to incorporate the two I tried to create a calculated field called Ignore Filter ->  { FIXED DATETRUNC('month', [Event Date]),[Person Group]: AVG([Value])}

 

I was assuming that this will ignore the User Name filter all together. However, when I use this calculated field in plot 1 instead of value, as soon I drag the User Name into the filter box either the Null user line or the valid user line disappear (depending on value in the filter). So I cannot incorporate both comparison lines together with the User Name plot.

 

I cannot create 3 independent plots since Tableau only allows to sync 2.

 

Any ideas how to solve this issue?

 

Thank you!

5 answers
  1. Oct 21, 2019, 9:46 PM

    See the attached

     

    Not certain I understand the difference between the groups but see if this points you in a direction

     

    you want to use the same data 3 ways so I created a union between the original data and 3 copies

    See the attached Not certain I understand the difference between the groups but see if this points you in a direction you want to use the same data 3 ways so I created a union between the original dat

     

    then with this I broke the data into 3 groups

     

    pastedImage_1.png

     

    and then this assigned values to the groups (not must be a single calc field)

    pastedImage_2.png

     

    and this is the result (see the red tabs) one is a chart the other the text table

    pastedImage_3.png

     

    and

    pastedImage_4.png

     

    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.

0/9000