Xcelsius Average IF & Average IF'S

Hi ,

I am forced to use this functionality ,But as we all know these are the functions which xcelsius will not support ..Can any one help me out on these..Is there any other logic for the same requirment...Or please let me know you expericene if you have faced during your dashboard development..