Forum Discussion

chrishnrh57's avatar
chrishnrh57
Regular Visitor
6 years ago
Solved

Rolling Average Excluding Zero

Hello,   I have looked through this forum quite a bit and i'm seeing solutions very similar to what i'm trying to figure out, but not exactly what I need.   I'm looking for a Rolling Average that...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi chrishnrh57,

    It is hard to find out your table structure and test from your snapshot. Can you please share some dummy data with the same table structure? 

    How to Get Your Question Answered Quickly 

    In addition, I'd like to suggest you use date function to manually define filter range instead of using time intelligence functions. (they do not support custom)

    Time Intelligence "The Hard Way" (TITHW) 

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi chrishnrh57,

It is hard to find out your table structure and test from your snapshot. Can you please share some dummy data with the same table structure? 

How to Get Your Question Answered Quickly 

In addition, I'd like to suggest you use date function to manually define filter range instead of using time intelligence functions. (they do not support custom)

Time Intelligence "The Hard Way" (TITHW) 

Regards,

Xiaoxin Sheng