topic Re: How to generate future values from average weekdays values? in App Development

How to generate future values from average weekdays values?

antonaks — Mon, 20 Dec 2021 21:08:46 GMT

Hello colleagues!

Could you please suggest how can I get values for future dates in the diagram expression.

I need to implement the next logic: all future values must be calculated as average from 8 previous weekdays. I have already implemented this algorithm in the load script but I need to move logic to front-end.

Thank you.

Re: How to generate future values from average weekdays values?

antonaks — Thu, 25 Jun 2020 09:39:37 GMT

Re: How to generate future values from average weekdays values?

antonaks — Tue, 30 Jun 2020 07:48:28 GMT

Up. Really, no one knows?

Re: How to generate future values from average weekdays values?

brunobertels — Tue, 30 Jun 2020 08:36:19 GMT

In the front End and in a straight table ou graph you will need first create the future date in your calendar

Then as mesure it could be something like

if (date>today(), mesure using above statement or using rangeavg() function , mesure )

regards

Re: How to generate future values from average weekdays values?

antonaks — Tue, 30 Jun 2020 09:29:29 GMT

Yes. I have already created a table with future dates and zero values. But the problem is in expression, I can't use AVG calculation on generated values. For example, I can generate values for the first 7 days, the next day must be linked to generated value.

Re: How to generate future values from average weekdays values?

brunobertels — Tue, 30 Jun 2020 14:44:20 GMT

Not sure but have a look to this : the AsOfTable

i tried in the past to make predictive value for futur date ( in fact without success due to my lake of Skills and Knowledge ) i found some approach with the asoftable and also with the linestM and LinestB function and rangeavg function.

See below my test

Appels Recus = real received call

My last date with real value was 16/08/2019 with 1549 received call

second column is a test with linest_m and linest_b that gave me values for greater date than 16/08/2019 and seemed to be a good result ( at least it was giving values)

And last column is a test with rangeavg who after several date reach to zero unfortunately

Sorry can't help more on this but surely the community will do

regards