MODE aggregation function in Time Series Insights ??

[vinod83k]

Please provide us with the following information:

This issue is for a: (mark with an x)

- [ ] bug report -> please search issues before submitting
- [ ] feature request
- [ ] documentation issue or request
- [ ] regression (a behavior that used to work and stopped in a new release)

Does Azure Time Series Insights supports MODE aggregation function?

Minimal steps to reproduce

Any log messages given by the failure

Expected/desired behavior

OS and Version?

Windows 7, 8 or 10. Linux (which distribution). macOS (Yosemite? El Capitan? Sierra?)

Versions

Mention any other details that might be useful

---

Thanks! We'll be in touch soon.

[shreyasharmamsft]

@vinod83k Hey, TSI currently doesn't support a mode() aggregation function. Would you be able to share what your use case for it is?

[vinod83k]

@shreyasharmamsft , we have a requirement to get the data which is occurring more frequently within a certain timeframe. For example, if I get [24,23,24,24,25] sensor values from IOT device per second and within in time-frame of 5 secs. The MODE() function will return 24, because this is the most recurring value in the dataset. Please let me know if you need more details on this.

[vinod83k]

@shreyasharmamsft , could you please help us in achieving this functionality or suggest something as how we can do this.. ??

[shreyasharmamsft]

@vinod83k Unfortunately we don't support this functionality yet. It's now something we have in our backlog (thanks to you!) but I cannot comment on when it'll could be made available, yet.

You can use a categorical variable to view the count of times you get each value. You can map to category 1 for a value of 23, category 2 for 24, and category 3 for 25. It wouldn't give you the mode but you can at least get a visualization that will help you determine what the mode is. I hope that helps!