How to group by on a count(Filed name) expression

[#1]

Hi , my source is below. I have a graph - where  ticket count is shown by Month day ( Dimension as Month Day and Expression as Count(Ticket) - attached object.

I have 3 shifts - shift1,2,3 - is there a way i can stack the bar(ticket count) for each day by shift - ie each bar will have now 3 colors, each color for each shift - basically the idea is show the ticket count per shift for each day

Thank you

[DATA]:

LOAD Ticket,

     [Assigned To],

     [Assigned To] as Resource,

     [Primary Affected CI],

     Application,

     [EON ID],

     DOMAIN,

     Opened,

     Closed,

     [Open Month],

     [Close Month],

     [Open Day],

     [Date Open],

     [Month Day],

     [Date Close],

     Updated,

     State,

     [Short Description],

     [Work notes],

     [Resolution List],

     [Restoration Description],

     [Assignment Group],

     [Actual Severity],

     [Time Taken],

     Minutes,

     Minutes as MinutesIM,

     Hours,

     [Ticket Open Time],

     Shift

FROM

[ Data.xlsx]

(ooxml, embedded labels, table is [Page 1]);

[sunny_talwar]

Have you tried adding Shift as your second dimension?

[trdandamudi]

May be as attached:

[#4]

i have created these subset tables to have it work for njow - but was told to us 3 set analysis expressions as a better practise

[Shift1 Data]:

LOAD Shift, Number as Shift1_Number, [Open Month], [Month Day],

Hours as Shift1_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift1';

[Shift2 Data]:

LOAD Shift, Number as Shift2_Number, [Open Month], [Month Day],

Hours as Shift2_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift2';

[Shift3 Data]:

LOAD Shift, Number as Shift3_Number, [Open Month], [Month Day],

Hours as Shift3_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift3';

[#5]

i have created these subset tables to have it work for njow - but was told to us 3 set analysis expressions as a better practise

[Shift1 Data]:

LOAD Shift, Number as Shift1_Number, [Open Month], [Month Day],

Hours as Shift1_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift1';

[Shift2 Data]:

LOAD Shift, Number as Shift2_Number, [Open Month], [Month Day],

Hours as Shift2_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift2';

[Shift3 Data]:

LOAD Shift, Number as Shift3_Number, [Open Month], [Month Day],

Hours as Shift3_Hours, Minutes

RESIDENT DATA Where Shift = 'Shift3';