Bar chart

[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

[sunny_talwar]

Would you be able to share a sample to check this out?

[Anonymous]

I have data in both these files

[Anonymous]

The outline alone is correct

I don't know what expression to use.

and for weekly data I have to roll up the dates keeping Friday as week end date.

please help with this

[settu_periasamy]

Hi,

Seems to the Table is not linked Properly

I think, if you correct that, the data will show proper.

[Anonymous]

how to connect the tables?

[vishsaggi]

You have to find a common field between two tables then rename one of the fields to the that field which you want to make a key. For eg. if you think POD and PODs should match. Then just rename the Field PODs to Like PODs AS POD.

[Anonymous]

I thought it will become synthetic key

so I reamed POD as PODs in one of the file

and the connection works fine

the problem is with the expression.

[Anonymous]

After joining the tables the values displayed at the points are corrected.

but consider the worked hr for soumya is 0 for all the days, it is showing some other value.

Only for first date it is showing correctly