I would like to know how to create a metric that sums up another metric for a period defined by a variable.
Metric A = Sales
Metric B = date (inventary)
Métrica C = Sales by period between inventaries
Metric A Metric B Metric C
Sales Inventary Salesda by period (Inventary)
01/01 100 0 0
02/01 50 1 150
03/01 125 0 0
04/01 75 0 0
05/01 150 1 350
06/01 100 0 0
07/01 25 0 0
Best answer by Moises MoralesView original
I believe it is possible to create such metric with the IF conditional. This way, whenever “1” is assigned to the Metric B, the Metric C would show the sum total of the values in the Metric A. You can find further details on our documentation here: IF-THEN-ELSE. As a side note, if you are having issues with the report itself, it may be ideal to open a ticket directly with our Support Team, so we can help you troubleshoot it.