I want to show a chart which shows the comparison between values of a dimention. So lets say we want to compare the average age of different departments. Until now I had to create every time a new chart and filter it inside to the certain department (sth like
Avg(If(Dep='Procurement', age, 0))
Now one could compare the charts at once. But if the values of the dimention should change, we had to adopt thes changes and add del or mod the charts.
So here comes the question: is there an easier way? I ve heard about cyclic groups , but from the first look they change the same chart and one department is shown at one certain time.
yes when there is only one dimention than it should be fine. but lets say i add some time dimention and maybe another one 'jobtype' or so. now its suddenly too much of info for one chart and the comparison is not really nicely shown
I'm not sure if this is really useful - to add a second dimension like jobtype or any period-field makes sense but to have all three dimensions within one object adds no real value - it will be more cluttering and confusing then useful and this by each kind of visualization. But if you want to show more go with Sunny's suggestion of using trellies.