I am trying to set up an insight where I want to show Student Score. Now I have to show Average, Minimum & Maximum. Currently in Insight am able to include the Student Score property only once and select Average or Max or Min but not all 3, but in Report Definition that is possible. If I even do it in a Data Page, am not able to show it now in Insight. How to achieve this requirement.
Yes, this is not possible through Insights. However, you can create a new landing Page → Create a new List View->Configure the data page → Report definition to display Min, Max, Average.
Same property usually cannot be used multiple times with different aggregations in one Insight, so showing Average, Minimum, and Maximum for Student Score together is not straightforward there. The recommended approach is to use a Report Definition that returns all three aggregates as separate columns, and then display that report in a List View or dashboard.
If you need a chart-based view, build the aggregations in the report layer first and then visualize the returned data. That is more flexible than trying to force all three calculations into a single Insight.
@Dinesh_Ponnusami Are you in the User Experience Expert Circle? I would like to move this under that area, so it can be found with other Constellation questions. However, if you are not a member you won’t be able to respond (until you join), so don’t want to just move on you.
Please let me know if you join and i’ll move.
you could create 3 insights, and put it all on 1 landing page or dashboard? end user its seamless, all in one spot. Only you know its 3
in fact you don’t even have to do that.
Finally had a chance to get my '25 Community Edition up and test, you can put 3 simple values on the same field.
but if you want a nice dashboard view, it would be better with 4 insights (average, min, max, and your list):
OOTB behaviour
If creating a dashboard is too much or contradicts other business needs. When you use this min, max and average, user can change this to see the other values. The business outcome can be achieved that way.
