topic Re: Bar chart report in App Development

Bar chart report

Anonymous — Sun, 19 Nov 2017 04:06:08 GMT

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

Re: Bar chart report

mdmukramali — Sun, 19 Nov 2017 06:46:37 GMT

Hi ,

PFA.

Re: Bar chart report

Anonymous — Sun, 19 Nov 2017 07:02:03 GMT

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'

Re: Bar chart report

mdmukramali — Sun, 19 Nov 2017 07:37:33 GMT

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

Re: Bar chart report

Anonymous — Sun, 19 Nov 2017 07:37:51 GMT

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

Re: Bar chart report

Anonymous — Sun, 19 Nov 2017 07:49:25 GMT

thank you ...

It worked well:)

Re: Bar chart report

mdmukramali — Sun, 19 Nov 2017 07:56:18 GMT

Hi ,

Try this

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

Re: Bar chart report

Anonymous — Sun, 19 Nov 2017 08:06:30 GMT

thanks a lot:)

Re: Bar chart report

Anonymous — Sun, 19 Nov 2017 08:30:47 GMT

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

Y it is not matching...pls help

Re: Bar chart report

mdmukramali — Sun, 19 Nov 2017 08:52:22 GMT

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

Re: Bar chart report

Anonymous — Sun, 19 Nov 2017 08:54:58 GMT

thank you for the help:)