Solved

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

  • 29 July 2021
  • 1 reply
  • 40 views

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

icon

Best answer by Moises Morales 29 July 2021, 17:54

View original

1 reply

Userlevel 1

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. 

Reply