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 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?
- Anonymous10 years ago
Drilling date hierarchies with interactions to other charts is not supported.
9 Replies
- BhaveshPatelSuper User
Is that all the tables are connected by relationships? What are fields that are connecting to each other.
- AnonymousNot applicable
The only connection between the two tables with the plotted data is trough the date table.
- BhaveshPatelSuper 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.
- AnonymousNot applicable
Drilling date hierarchies with interactions to other charts is not supported.