Results locked by attribute

  • 8 March 2021
  • 1 reply

Hello! I’m having a problem trying to lock the agregation level in a result. 

I have a report showing : store, articule, sales and stock. I need that the sales metric doesn’t change despite the store.

For example: if one articule had 3 sales in one store and 2 sales in other one, the report should show 5 sales no mather what store I am looking. 


Best answer by Petr Olmer 9 March 2021, 20:42

View original

1 reply

Userlevel 2

Hi @Manu Meic,

You have to create a custom metric and use the BY ALL statement.

If the metric returning 3 and 2 looks like SELECT SUM(Sales), the metric returning 5 would be SELECT SUM(Sales) BY ALL Store.