Can I decide line chart or bar chart depand on which dimension I select?
hi,
I have a chart with 2 dimensions, one is month the other is department. And these 2 dimensions are in the same cyslic dimension group. I can switch them by click the icon.
My question is :Can I decide line chart or bar chart depand on which dimension I select? When I select month as dimension, the line chart shows. When I select department, the bar chart shows.
How can I do this? Could you give me some tips please? thanks.
I don't think you can do it dynamically on the object itself. You could build two charts, one for each one of the situation. Both of them would have the cyclic dimension. Then, you could use
GetCurrentField( groupname )
as a visibility condition to hide one of the charts.