Short version is :
when a user clicks on Dimension2 of my chart, I want the selected value to be applied to Dimension1 instead of Dimension2.
Longer version with background is ......
As per the title, I am working with a Hierarchy.
I have my source 'Adjacent' table. (Node-Parent)
I used 'Hierarchy' to generate a 'PATH' table.
Also used 'HierarchyBelongsTo' to create a 'Branch' table.
For the UI, I am using a Gant Chart. (Grouped bar chart with Bar Offsets)
Dimension 1 = 'BranchID'
Dimension 2 = 'NodeID' (sorted by time)
Expression = max([Node_EndTime]) - max([Node_StartTime])
Offset = min([Node_StartTime])
Works lovely, and visualises the time structure of my hierarchy tree wonderfully.
However, when it comes to filtering the chart tree, I have limited behaviour.
If use selects a node (bar) in the chart, it filters by NodeID.
What I would like, in a perfect world, if that the selected node becomes the new root for the displayed tree.
So, in effect, when a user clicks in a NodeID, I actually want to filter the chart :
where [BranchID] = Clicked [NodeID]
Is this possible ?!?!
Thanks in advance