Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have the following dimensions:
* employee name
* date
* machine name
expression : number of hours
so it will show how many hours a certain employee worked on a certain machine on a certain day.
what's a good way to display this? for bar chart it's one dimension too many (stacked)
any ideas?
Try mekko chart.. there the width of the bar will vary according to the expression.
HTH
Sushil
Try to use either block chart or Radar chart which you want both are Good for reporting purpose to understand
Regards
Mohit
Well, technically a bar chart chart can show three dimensions and one expression. You get grouped stacked bars. And a block chart can also show three dimensions and an expression. And there's the trellis option too. But you should really first ask yourself what question(s) the chart should answer. If all you need is to see how many hours a certain employee worked on a certain machine on a certain day then a straight table or pivot table is probably the best solution. Don't underestimate the expressive qualities of a straightforward table (and sorting and highlighting can increase that some). If you need to compare between employees or compare between days or machines for a certain employee a bar chart may be a better choice. You may need more than one chart if there are really more than one question that should be answered.
Hi Amien,
Use straight table this is good view for detail for Emp., Machine and day wise