Metrics and MAQL

Metrics and MAQL

  • 59 Topics
  • 174 Replies

59 Topics

Metric that sums up another metric for a period defined by a variable

I would like to know how to create a metric that sums up another metric for a period defined by a variable.Example:DataMetric A = SalesMetric B = date (inventary) ObjetivoMétrica C = Sales by period between inventaries                 Metric A            Metric B                            Metric C                Sales                Inventary            Salesda by period (Inventary)01/01    100                         0                                             002/01    50                           1                                             15003/01    125                         0                                             004/01    75                           0                                             005/01    150                         1                                             350        06/01    100                         0                                             007/01    25                           0                                             0 Thanks