Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Mar 19, 2019, 1:45 AM

Is it possible to interactive Dashboard via other worksheet

Hi, guys, I have a problem when I try to interactive Dashboard.

sorry, it is difficult for me to show the real data, I would like to try my best to describe my problem.

I have 3 worksheet on my Dashboard.

The WorksheetA's  X axis is date, Y axis is Process (001,002,003...)with Yield Rate.

For example, When I click process001(not single data, the whole row) on WorksheetA, it shows me the everyday's Defective Rate of that Process001 on WorksheetB.

Then, when I click one of the date on WorksheetB, it shows me all the Details of that particularly day on WorksheetC.

All three date source are linked by Process in real data.

 

My problem is,

When I  clicked Process001 on WorksheetA, it should filter process001 on WokrsheetB and WokrsheetC as well.

At least it is what I think.

But then I click WokrsheetB's date to check the details on WokrsheetC.

Sometimes the day I chose shows on WokrsheetC has both Process001 and Process002's data.

I thought I already filtered it on my step one, which when I click  process001 on WorksheetA.

 

I would like to know, is it possible to filter via other worksheet.

if I click A to check C, no problem,

but when I click A to check B, then through B to check C, the data goes wrong.

 

Sorry for the messy question.

 

I hope someone can help me.

thanks a lot.

6 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Mar 22, 2019, 6:56 AM

    Hi, I upload a sample here,

    On my dashbaord you can see 3 wroksheets,

    The worksheet of Yield Rate is using data source "Yield Rate",

    The worksheet of Defective Rate and Details are using data source "Defective Rate".

    I used data blending for these 2 data source, their linking fields are Date, Process and Detail.

     

    Hi, I upload a sample here,On my dashbaord you can see 3 wroksheets,The worksheet of Yield Rate is using data source

    What I want to do is,

    ①　When I click "PC_A" on "Yield Rate" worksheet, it should filtered PC_A on worksheet "Defective Rate" and "Details".

    ②　Then I choose a date on "Defective Rate" worksheet. It should filter both PC_A and that date on worksheet " Details".

    The order is Yield Rate→Defective Rate→Details

     

    My problem is when I check one of the Details, other process is showing on my filtered data too.

     

    I want to know the problem and how to fix it.

     

    Thank you!

     

    Luyun

Write an answer...
0/9000