I would like to know how to create a metric that sums up another metric for a period defined by a variable.
Example:
Data
Metric A = Sales
Metric B = date (inventary)
Objetivo
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
Thanks
Best answer by Moises Morales
View original