Hi,
I have a line chart where months are in x-axis and price is in y-axis. I don't have data for the full year.
I have created the following structure If(price_this_month > 0, price_this_month, variable_last_valid_price)
variable_last_valid_price is price of the current month, because that is available.
This works fine when I select one product and the line continues at this month level. However, the variable_last_valid_price sums together when there is two or more products.
How to use a variable separately for each product or is there other ways to use the last available data in the line chart?