Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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?