Aggregation over timeline

[ChrisAbeln]

From a table that has probes over time a typical use case is to aggregate over time. The aggregation is dependent on the current filter applied (e.g. Slizer, DateTime range) and must be calculated in the view dynamically.

[chughes]

Will, Yes I think that's what Christian is saying. It'd be great feature.

[Pietro1]

¨Hmm.... maybe I have mixed up the two words Aggregate and Accumulate? My thoughts was to create a accumulated value over selected timeline. Ex. Jan Accu-value = Jan value. Feb Accu-value = Jan+Feb values. Mar accu-value = Jan+Feb-Mar values.... and so on

[Pietro1]

In addition to view values as sum, average, min, max etc. an option in values to accumulate the 'previous' value. Ex. Jan Accu-value = Jan value. Feb Accu-value = Jan+Feb values. Mar accu-value = Jan+Feb-Mar values.... and so on

[shaun_rickman]

Group by week would be great in the hierarchy for sure!!! Now that i don't really have to have a date table this is really needed to make it complete!!

[sarnath_kannan]

I am not sure what this feature is exactly asking for. But this is what I need: I have events which span time-interval: t1 start, t1 end. And event has attribute Now, I want a time-line which is bucketed like every 20 seconds or 1 minute and then I want to aggregate attributes for whichever events that were active in the time-interval bucket. Hope I am clear.

[nishalit]

This can be achieved through a DAX measure. ​