topic Re: stack bar charts, segments in App Development

stack bar charts, segments

joeybird — Wed, 30 Mar 2016 09:14:08 GMT

Hiya

I want to create a time line, no of days using a stacked bar chart. Not a line chart.

where bars are showing left to right (to show timeline)...rather than bottom to top

department is the first dimension, and customerID is the second dimension

The measure is the sum(Number of Shopping days)

how do I change this sum so it does not group the totals... is there such thing as a aggr sum?

please help

Re: stack bar charts, segments

Gysbert_Wassenaar — Wed, 30 Mar 2016 09:24:20 GMT

I don't understand what you mean with 'does not group the totals'. Can you explain with an example?

Re: stack bar charts, segments

joeybird — Wed, 30 Mar 2016 09:37:48 GMT

Hiya

each department has a colour

1 = green

2 = red

3 = blue

a customer (ID1) has spent 10 days in green, 15 days in red, 2 days in green , and finally 10 days in blue.

the stack chart is showing me

ID1 ...Green, Red, Blue (segments)

12 15 10

I need the stack to show

ID1 ...Green, Red, Green Blue (Segments)

10 15 2 10

please help

Re: stack bar charts, segments

Gysbert_Wassenaar — Wed, 30 Mar 2016 09:43:09 GMT

How are the green segments different? What attribute is different?

Re: stack bar charts, segments

joeybird — Wed, 30 Mar 2016 09:50:54 GMT

Hiya

I am trying to show the different is the number of days a customer has spent shopping back and forth different departments over a year (Time line) - difference in days spent in each department, and sometimes the department is revisited.

the bar ID reads left to right Y AXIS

along the bottom is the measure...number of days X AXIS

its like a time line, but instead of date on the X AXIS is I have number of days

start date

Green 01/01/2015 - 10 days

Red 11/01/2015 15 days

Green 27/01/2015 2 days

Blue 30/01/2015 10 days

ID1 ...Green, Red, Green Blue (Segments)

10 15 2 10

basically bar is showing 3 segments, I need it to show 4

please help

Re: stack bar charts, segments

Gysbert_Wassenaar — Wed, 30 Mar 2016 09:52:05 GMT

Ok, so you need to use start date as dimension too.

Re: stack bar charts, segments

joeybird — Wed, 30 Mar 2016 10:23:34 GMT

I have now

Department & [Start Date] - as Dimension. its working, but I need the segments to be same colour

please help

Re: stack bar charts, segments

Gysbert_Wassenaar — Wed, 30 Mar 2016 10:33:00 GMT

Do you have a field that contains the color values?

Re: stack bar charts, segments

joeybird — Wed, 30 Mar 2016 10:34:48 GMT

Hiya

tried that next step and its worked thank you x

Re: stack bar charts, segments

Gysbert_Wassenaar — Wed, 30 Mar 2016 10:40:17 GMT

Great. And you're welcome.

Re: stack bar charts, segments

joeybird — Wed, 30 Mar 2016 10:41:14 GMT

I wish you could mark two sections are correct x

Re: stack bar charts, segments

Gysbert_Wassenaar — Wed, 30 Mar 2016 10:55:31 GMT

That's not possible, but you can mark other posts as helpful.

Re: stack bar charts, segments

joeybird — Wed, 30 Mar 2016 11:47:34 GMT

done x