Aggregate line graph using three fields

Hi Espen1515,

So I have tried replicate it with data you have provided.

I have managed to get "something" from the graph as it should look it. However, the main issue is that you need for legend one column which will contain all the statuses (BL, Curr act and Early finish). And as the axis you would need all the dates.

So you need to make columns where every PO will have the start date and all dates before it will be dismissed.

So you are makin a "cube" as it is called for making data models. In this case you can imagine it as basic graph with X, Y and Z coordinates (x,y,z)

So you would have Statuses as the legend (Z coordinate with value 1) X coordinate as the date value and Y coordinate as the count of POs involved.

In this raw data case you have it, but you are missing dates between which is making gaps in the graph.

What you are looking for is to make custom table, where you will collect all POs with Activity description you would like to have as first column. Second column would be the date and third column would be the value for legend.

So you would Have 12 month for each PO and status. In max case 12(months) * 3 (statuses) per PO.

I am sorry, but I am unable to make the formula for that custom table as I am struggling with similiar case myself :(