Creating a combined graph with contract hours vs planned hours

[CaseumMP]

good day,

I want to create a graph with planned hours of a filtered group (time series data with 1 row for each person, date and project) as a vertical bar chart, with a line depicting the contract hours of the filtered group. The planned hours data I have available is time series data (weekly data) that looks something like this:

Name	Project	Date	hours planned
A	X	1-1-2023	10
A	X	1-7-2023	15
A	Y	1-7-2023	8
B	X	1-1-2023	12
B	X	1-7-2023	20
B	Y	1-7-2023	5
B	Z	1-14-2023	2

Contract hours on the other hand is not a time series data set that looks like this:

Name	Contract hours (weekly)
A	36
B	24
C	36
D	40

How do I create a combined graph with these data sets, where the contract hours data properly aggregates when I move along the date hierarchy?

Thanks in advance!

[Anonymous]

HI @CaseumMP,

I think you should provide more detail fields to help 'table 2' records to mapping with first table records. (current it does not exist any related fields to accurately mapping with table records)

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng