Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a leakage report using bar chart.
I want one bar showing actual allocated hours,
2nd bar showing hours worked and 3rd bar showing leakage(=actual -allocated)
I want it daily as well as week wise.
if I use sum(hours worked) expression for daily it is totalling the hours for the particular resource .
Please help me with this
please find the sample attachment
The values are displayed wrong
Hi Dhivya,
The Dailyreport and Resource Tables are connected with POD.
i think you have to consider resource also in the link.
try the below script:
Directory;
LOAD POD,
[User Story],
[Description/Ticket],
Status,
Resource,
Technology,
Date,
Hours,
POD&'-'&Resource as KEY
FROM
dailyreport.xlsx
(ooxml, embedded labels, table is Sheet1);
Directory;
LOAD Role,
Name,
POD as Resource_POD,
[Hours Allocated],
[Daily Hours],
POD&'-'&Name as KEY
FROM
resource.xlsx
(ooxml, embedded labels, table is Sheet1);
Hi ,
PFA.
Thank you..
But check with the name 'Soumya'. the worked hour is always '0'.
But it is showing the value wrong
and for 'Nishant' the records are present but it is showing ' no data to display'
Hi Dhivya,
The Dailyreport and Resource Tables are connected with POD.
i think you have to consider resource also in the link.
try the below script:
Directory;
LOAD POD,
[User Story],
[Description/Ticket],
Status,
Resource,
Technology,
Date,
Hours,
POD&'-'&Resource as KEY
FROM
dailyreport.xlsx
(ooxml, embedded labels, table is Sheet1);
Directory;
LOAD Role,
Name,
POD as Resource_POD,
[Hours Allocated],
[Daily Hours],
POD&'-'&Name as KEY
FROM
resource.xlsx
(ooxml, embedded labels, table is Sheet1);
In weekly chart, when I user Weekend(date) it shows me Sunday date.
but I want to display Friday date.
please help with this also
thank you ...
It worked well:)
Hi ,
Try this
=Date(Weekend(Date)-2,'DD/MM/YYYY')
thanks a lot:)
even then the values of nishant and Priyanka does not match with the given data:(
Y it is not matching...pls help
Hi,
in Both the Excel files POD value should be same ( Case Sensitive)
for Nishant Case in Resources Excel file : in Plan 'p' is same letter
POD : Protection plan
in Daily Report Excel file : in Plan 'P' is Capital letter
POD: Protection Plan