Hi,
I have bar chart 'Chart A ' with dimension closecode and expression as count of caseid. And another bar chart 'Chart B' with dimesnion as Engineer and count of caseid by excluding certain closecode.
Ideally if i am choosing the specific Engineer in the chart B who has the caseid count as 120 by excluding certain closecode the other chart also should show only the closecode related to the selection. But the same is not happening. It is showing all closecode and count related to engineer.
All the feilds are from the single table.
My understanding ---- since Engineer is the dimension in the Chart B the Chart A valuesare getting selected based on the Engineer dimesion . Hence chart A displays all the closecode related to engineer not based on the expression value.
Please correct me if i am wrong.