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 i...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

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

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    10 years ago

    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.

     

     

    • BhaveshPatel's avatar
      BhaveshPatel
      Icon for Super User rankSuper User
      10 years ago

      Step 1 Create a relationshipBargraph of Table 1 Date must come from DateTableBargraph of Table 2 Date must come from Date TableCrross filter behaviour

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Thanks for a thorough answer but unfortunately it doesnt solve my problem! I have already done what your suggesting and highlighting works well, but i want to drill date hierarchies on both when drilling at only one of them. That is: when i press the 2015 bar in one chart it shows me all the months in 2015 and i want to second chart to do the same.