Hi @sagmukhe thanks for the reply,
my concern with avgOver is I need to pull the ID into the table to make the value work right?
Because the requirement for the chart is only to have activity and the expected value inside (line chart)
if I’m using avgOver I need to pull ID into the chart also, please correct me if I’m wrong…
And also the behaviour kind of different.
I put the result below because avgOver will average both A and C because it’s same activity.
while if I’m using avg, for A and C I will sum and I only average for ID A…