Hi,
I want to ask something un-usual, is there any way to make a column chart with dynamic drill, not pre-defined in chart data properties.
I have a employee's data sources, and I have a combo box with option (gender, races, religion, education), and I have a column chart with Department as a default column bar.
So I want to made something like this, when I select the combo box with gender option, and when I click one department column bar then the chart will drill through to gender column with selected Department earlier as a filter, and next when I select religion option in combo box and I click female column bar, it will drill through religion column bar with selected Department earlier and female as a filter.
So the drill through filter are dynamically run based on combo box selected value.
Can I implement that using this Dashboard Platform, I have wasting my day to accomplish it but no luck.
Please give me some advice for it.
Regards,
Ranto Yusuf