Forum Discussion
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...
Drilling date hierarchies with interactions to other charts is not supported.
BhaveshPatel
Super User
Super UserIs that all the tables are connected by relationships? What are fields that are connecting to each other.
The only connection between the two tables with the plotted data is trough the date table.
- BhaveshPatel
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
Step 1 Create a relationshipBargraph of Table 1 Date must come from DateTableBargraph of Table 2 Date must come from Date TableCrross filter behaviour