Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Drill Date Interactions

l have a page with two separate 100 % stacked column charts. They share the same date x-axis from a table containing only dates but the values come from two other tables. When i drill down on dates in one chart i would like the other chart to be drilled down as well. I have set interactions to filtering and enabled drilling on both but when i drill down on one nothing happens with the other, what am i doing wrong?

  • Anonymous's avatar
    Anonymous
    10 years ago

    Drilling date hierarchies with interactions to other charts is not supported.

9 Replies

  • Is that all the tables are connected by relationships? What are fields that are connecting to each other.

    • Anonymous's avatar
      Anonymous
      Not applicable

      The only connection between the two tables with the plotted data is trough the date table.

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User

        You should always select the Date value from your date table and not from your Table 1 or Table 2. 

         

        As the relationship always flow from 1 to many direction(default), this will cross filter both the tables because they are connected with the data table relationship.

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    Drilling date hierarchies with interactions to other charts is not supported.