AnsweredAssumed Answered

Use of analytics in data flow

Question asked by danieledilorenzo on Apr 19, 2019

Hi community, I have following question:

 

cube A by Day

cube B by Month, tu be populated with the AVG from cube A (excl zeros) by each month.

 

Even if there're many ways to obtain this, I try to do this with analytic function Average Not Zero Values, without success

 

I don't understand how to set the analytics panel. please note that this process run on more than one month

see picture 

Outcomes