Bar chart report

[Anonymous]

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

[mdmukramali]

Hi ,

PFA.

[Anonymous]

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'

[mdmukramali · Accepted solution]

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);

[Anonymous]

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

[Anonymous]

thank you ...

It worked well:)

[mdmukramali]

Hi ,

Try this

=Date(Weekend(Date)-2,'DD/MM/YYYY')

[Anonymous]

thanks a lot:)

[Anonymous]

even then the values of nishant and Priyanka does not match with the given data:(

Y it is not matching...pls help

[mdmukramali]

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