Adding several metrics

  • 9 August 2022
  • 5 replies

Userlevel 3
Badge +6

Hello all, 


I want to aggregate 7 metrics with the following dimensions: version, month, order_id. 

One of these has checkout_id dimensions in addition, then i removed it. In addition, 2 metrics (Offer_order_Level and Wallet_order_level) have day in dimension structure instead of month (for a matter of optimization), however, month is a property of day. I do not achieved to aggregate those metrics. Could you help me please? Thanks a lot 😉




Best answer by francois 9 August 2022, 14:54

View original

5 replies

Userlevel 6
Badge +13

Hi Alix,
To go from Day structure to Month, you simply have to type [BY: Day.Month].

I think you should try to open several Formula Playgrounds in parallel to first set all members to your desired structure, so version, month, order_id then add them up. Otherwise, Pigment will try to multiply all cells by all dimensions which hits the cardinality limit quickly (plus it adds no value).

Hope this helps!

Userlevel 3
Badge +6

Thanks a lot François! I understand the logic, but I think it’s heavy because it’s not working… :/ 

Userlevel 3
Badge +6

It gives that - but still not working and lagging: 


Userlevel 3
Badge +5

This one is solved now I believe 😁

Userlevel 3
Badge +6

Yes sure, sorry for missing updating! Thanks Yohann 😁