1 2 Previous Next 15 Replies Latest reply on Oct 12, 2018 11:48 AM by Shinichiro Murakami

    Independent Data Sources and Filter Dependency

    Gaurav Bhatnagar

      Dear Friends,

       

      I am using two data sources in my dashboard without blending or linking them. My "Data Source 2" is very large. I have created Action  filters between all 3 visualizations. If I select values from Visualization 2 then I am able to see related values in Visualization 3 BUT when I select values in Visualization 1 then it only updates Visualization 2 not Visualization 3. My Action Filter configuration is as below:

       

      Action Filter 1:

      Run On : SELECT

      Source Sheets: Data Source 1

      Target Sheets: All

       

      Action Filter 2:

      Run On : SELECT

      Source Sheets: Data Source 1

      Target Sheets: Visualization 3

      Target Filters: DataSource1.KeyField1 = DataSource2.KeyField1

       

      Action Filter 3:

      Run On : SELECT

      Source Sheets: Visualization 2

      Target Sheets: Visualization 3

      Target Filters: DataSource1.KeyField1 = DataSource2.KeyField1

       

      I am trying to make all Action Filters to work seamlessly. Currently I have to explicitly SELECT by clicking on Visualization 2 to render related values in Visualization 3. What other techniques, methods can be applied to make this happen? Any suggestions will be a great help.

       

       

       

       

      Thanks,
      Gaurav

        1 2 Previous Next