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.
7 Comments
- Will, Yes I think that's what Christian is saying. It'd be great feature.
- ¨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
- 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
- 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!!
- 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.
This can be achieved through a DAX measure.
- Status added:Completed
