1 Reply Latest reply on May 28, 2013 1:23 PM by Tracy Rodgers

    Applying filters to multiple reports in a dashboard with different Datasources

    PR R

      Hello,

       

      We would some inputs or ideas around the challenge we are facing in building a dashboard.

       

      Scenario:

       

      We have a dashboard (Workbook) consisting of 5 reports (Worksheets). For now we have built 3 reports out of the 5. Among the 3 reports, 2 are from one data source (with one table T1) and the other one is from a different data source (One table T2).

       

      The structure of the data sources are like below:

       

      T1:

       

      Day, Week, Month, Year, Region, State, City, Measure1, Measure2

       

       

      T2:

       

      Day, Week, Month, Year, Region, State, City, Measure1, Measure2

       

      One thing to note here is that the tables are at the same level considering the dimensions granularity, but T1 is aggregated at that level (one row per combination of dimensions) whereas T2 is not aggregated. So there will be multiple records per combination of dimensions.

       

      Ex:

       

      T1:

       

      Day,       Week,   Month,                 Year,      Region,                 State,    City,       Measure1,          Measure2

      10,          2,            1,                            2013,     North East,         XY,          AB,         100,                        300

       

       

      T2:

       

      Day,       Week,   Month,                 Year,      Region,                 State,    City,       Measure1,          Measure2

      10,          2,            1,                            2013,     North East,         XY,          AB,         10,                          30

      10,          2,            1,                            2013,     North East,         XY,          AB,         20,                          30

      10,          2,            1,                            2013,     North East,         XY,          AB,         50,                          60

       

      Issue:

      The requirement is to apply filters across all the reports in the dashboard. But with reports pulling data from different data sources, we are not able to apply filters to all the reports.

       

      Work Arounds we have tried:

       

      1. Created parameters and used them instead of filters, however we are not able to implement cascading of filter values using parameters when there is an hierarchy of filter  Ex: Year, Month, Week, Day
      2. Added both the tables (T1, T2) to the data source and tried joining them, but since one is at aggregated level and other not, there were duplicating measures (incorrect data).
      3. Tried creating Location and Time dimension tables and have put measures into a fact tables,  and tried joining the tables with in Tableau, but Tableau allows to have only one primary data source in the join of multiple data sources where as we have 2 primary tables in our case (Time & Location).

       

      Any ideas/inputs in resolving this would be really helpful. Thanks

       

       

      Regards,

      Reddy