Hi @Anonymous ,
Do you want to sum the hours that ids are the same?
Based on your screen shoots, it seems that you have four id columns and four hours columns.
Could you tell me: do you only have one id column that is not blank in one item?
For example:
record1: only id1 has value, other id columns are blank
record2:only id2 has value, other id columns are blank
If so, issue will be a little simple.
I assume that yes.
Then please try to set the chart's Items:
AddColumns(
GroupBy(
AddColumns(listname,"id",Concatenate(Project_ID1,Project_ID2,Project_ID3,Project_ID4),
"hours",Project_ID1_hrs+Project_ID2_hrs+Project_ID3_hrs+Project_ID4_hrs
),
"id",
"sameid"
),
"sumhour",
Sum(sameid,hours)
)
//the id column will be project id, sumhour column will be the sum of hours based on project id.
Best regards,
