Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data for 3 people for the amount of hours worked in December, January and February.
Instead of having 1 bar per person showing hours worked I would like the chart to show hours per month by person. Example from excel below.
If I can do this without re-loading the data that would be best.
Thanks
Hi Michael,
So put as dimension name and month and put sum(hours) as expression
you should get the right result
best regards
Christian
Hi
Not sure if I have understood you properly, but just change the order of the dimensions = promote Month above Person.
HTH
Jonathan
Hi Michael,
So put as dimension name and month and put sum(hours) as expression
you should get the right result
best regards
Christian
Hi Michael,
so currently you have only one column per person showing the total nr._of_hrs_worked?
=> Just make three expressions out of this one (guess it's sth. like a sum?) and use
set_expressions to specify a certain month.
(sth. like >>> sum({1<Monat = {"Jan"}>} [hrs_worked]) <<<)
HTH
Best regards,
DataNibbler
Hi Michael,
you have to add a second dimension 'Month' into the bar chart.
Please try.
Burkhard