search

Azure-Samples / Azure-Time-Series-Insights

Sample modules written in different languages that can be used as templates for applications needing to query Time Series Insights
MIT License
21 stars 31 forks source link

MODE aggregation function in Time Series Insights ?? #14

Open vinod83k opened 4 years ago

vinod83k commented 4 years ago

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 commented 4 years ago

@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 commented 4 years ago

@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 commented 4 years ago

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

shreyasharmamsft commented 4 years ago

@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!