Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a chart in the front-end that has some summary statistics on each field and is reactive to user selections.
I know how to do $Field and $FieldNo in a table to produce a list of fields. However, I am having trouble adding measures to the table that evaluate on each field.
Does anyone know how to make something like below?
$Field | Average | Median | Sum |
Field1 | <average of values in Field1> | <median of values in Field1> | <sum of values in Field1> |
Field2 | <average of values in Field2> | <median of values in Field2> | <sum of values in Field2> |
Field3 | <average of values in Field3> | <median of values in Field3> | <sum of values in Field3> |
Could you please share your data ?
This should be able to work with any dataset. $Field is a system field.