Display Repeating Group Data in a Graph


I would like to display a graph (I’m using Thimo’s ApexCharts.js and he said that this is a General Bubble question not a question for him) that shows performance of a selected stock and the S&P 500. Stock price is quarterly. Both are stored in my bd like this:

In order to compare the selected stock and the S&P 500, I have to convert the starting price of each stock to 100 with this formula (100/Stock Price:First Item) then multiply the integer (100/Stock Price:First Item) to the rest of the stock prices.

In a repeating group it would look like this:

Stock Price:First Item
Stock Price: Second Item * 100/Stock Price:First Item
Stock Price: Thirds Item * 100/Stock Price:First Item
Stock Price: Fourth Item * 100/Stock Price:First Item

Screen Shot 2023-06-06 at 5.23.21 PM

Screen Shot 2023-06-06 at 5.23.30 PM

***My question is how do I display this data from a repeating group in a graph or is there another way to compare two stocks that need to be converted to 100 first?

Thanks in advance for the support.

This topic was automatically closed after 70 days. New replies are no longer allowed.