Lifecycle stacked bar chart with dates from column headers

[Anonymous]

Hi all,

Really struggling with this one (maybe because of the way the data is laid out?)

Resource	Apr-16	May-16	Jun-16	Jul-16
Dave	Application	Interview #1	Interview #2	Job Offer
Sarah		Application	Interview #1	Job Offer
Mike	Application	Interview #1	Interview #2	Job Offer
Jane			Application	Interview #1

I'm trying to achieve a stacked bar chart showing the months along the bottom, with a count of the individual 'recruitment stages' along the side - any ideas would be really welcomed

thanks,

Pokes

[Anonymous · Accepted solution]

Hi,

You can apply crosstable in your data, doing so will transform your data into this:

Resource	Month	Data
Dave	Apr-16	Application
Dave	Jul-16	Job Offer
Dave	Jun-16	Interview #2
Dave	May-16	Interview #1
Jane	Apr-16
Jane	Jul-16	Interview #1
Jane	Jun-16	Application
Jane	May-16
Mike	Apr-16	Application
Mike	Jul-16	Job Offer
Mike	Jun-16	Interview #2
Mike	May-16	Interview #1
Sarah	Apr-16
Sarah	Jul-16	Job Offer
Sarah	Jun-16	Interview #1
Sarah	May-16	Application

CrossTable(Month, Data)

LOAD Resource,

     [Apr-16],

     [May-16],

     [Jun-16],

     [Jul-16]

FROM

[..\sample2.xlsx]

(ooxml, embedded labels, table is Sheet1);

And then you can easily create your chart.

1. Create barchart

2. Put Month and Data as Dimension

3. Count(Data) as expression

[Anonymous]

thanks Yddona, I'll try this at work later today...