For a Dashboard with a series of KPI's we have to elaborate more than 5000 entries,
Because we have to calculate median, mode, min, max on a series on time range on a actions log.
How we can achieve that using only records and not doing some use of stored procedure?
Discussion posts and replies are publicly visible
Some of your requirements should be easily covered by the standard aggregation functions.
i know, and if i understand well the "a!measure" function with numbers do it well and can manage more than 5000 entries... The problem i suppose that can be with time duration. You think that a good approach can be conversion of time in a integer base?