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?
I typically try the most simple and obvious approach first.
Thank you, yep, obviously, but the a!measure that go on more than 5000 dont have the mode, and if i understand well, cant elborate times, but only numerical datas. am I right?