Hi Folks,
I´m having a problem to add (in the same report) data inputed in GD by CSV sheet ($ sales monthly from 2020 to 2023) and data from Totvs ERP connected by API haveing current $ sales . I need to compare monthly, year to date $ sales, but data coming from different sources (CSV uploaded sheet in GD and ERP API conection). I did a metric where I can read data from CSV, from 2020 up to 2023, but i cannot insert another metric to read 2024.
How can connect them? and after connected, is it possible to reffer YTD months sales using PREVIOUS or NEXT?
thank you so much.