Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Am trying to get below output with my actual data.
I have some sample data(Main/NoShow) in two sheets and looking for below desired output.
I have tried with apply map and lookup but not getting what exactly looking for.
Any suggestions will be appreciated.
Kindly help!!!
May be attached?
To get correct format use this?
Date(MonYr,'MMM-YY') as MonYr,
Hey Anil thanks for your quick suggestion.
am unable to open your attached as am using only personal edition.
Can you paste your script here??
Also find attached sample one and correct If am anything wrong.
You have to load this way
Script:-
LOAD Date(MonYr,'MMM-YY') AS MonYr,
Emp,
Dept,'EmpNonshow' as TabFlag
FROM
NoShow.xlsx
(ooxml, embedded labels, table is Main);
Concatenate
LOAD Date(MonYr,'MMM-YY') AS MonYr,
Emp,
process,'Noshow' as TabFlag
FROM
NoShow.xlsx
(ooxml, embedded labels, table is NoShow);
Chart Expression:-
Dim:- MonYr
Expre TOTAL HC:- =Count ( {<TabFlag={'EmpNonshow'}>} Emp)
Expre Noshow Emp :- =Count ( {<TabFlag={'Noshow'}>} Emp)
Expre Non Noshow Emp :- =Column(1)-Column(2)