Crypto portfolio value displayed over months

So I am building a crypto portfolio app and I want to display the portfolio value over months, the way I am building it is with logs for example:

Date: 08.03.2024 Value: 500$,
Date: 09.03.2024 Value: 300$

Date: 08.04.2024 Value: 600$
Date: 12.04.2024 Value: 400$

Now I want to group this by date find the average of the value data field and display that as that month’s portfolio value e.g. March Portfolio Value 400$, April Portfolio 500$.

How would you do the grouping, aggregation, and logic for a feature like this? Thank You.

1 Like

You can use the :group by feature after “Do a search for”!

2 Likes

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