Hi,
I want to build a graph that will show cumulative of only new items by week from a table that has 2 columns (see attached as example). In the table, there are 91 different type of fruits that link to the date which is from 01/02/2024 - 9/29/2024. Below is the desired graph. The steps so far I took to get the graph seems not too effective/efficient. I wonder if anyone has more effective (JSL) way to do it?
Steps I used to generate the graph:
1) create a column in the same table with Formula(Week Of Year(:Date)).
2) summarize table N(Fruit) by Fruit and WW
3) in summary table of 2) , add a column (Count of WW) with Formula(Col Min(:WW, :Fruit))
4) summary table Mean(Count of WW) by Fruit
5) summary table N(Mean(Count of WW)) by Mean(Count of WW). I then manually add rows with value = 0 to any missing WW because those week has no new fruit. This is the table then I used to build the graph using statistic = cumulative.
