Scalar, selection of the consolidation math possible?

[berndParticipant]

Got a nice scalar / heatmap for multiple values of each x/y – field, which are for x the hours and y the weekday.

As the numbers looks like, scalar is calcuting the average / mean for each field, if this single x/y combination is present in data.

Is there any way, to select the kind of calcutation?

csv file with the used data

 

[berndParticipant]

Sorry, information not clear:

For each x / y field there are multiple values in the data.

[dgteamModerator]

The scalar field command does not do any calculation.  It only shows the values, and the last values in the table are the ones shown.

To illustrate:

Now, add a repeated row and notice how the value in the field is last in the table.

Instead, you can use the Pivot command to group based on your x and y.  Try selecting the columns and adding the Pivot command.  This command has a place to select what to output.  Here we show the count.

 

If you want the mean value, select that and then use the gear menu to Extract the calculated values.

Now, the mean values are in your table, and they can be input to the scalar.

In the future, we may add some calculations into the scalar, but this would be the approach to use for now. Essentially, you are creating a date of pipeline where the output from one command can be used as the input to another.

 

[berndParticipant]

Thank you for your help!

intermediate step with the pivot command enables now more, than expected.

Have a nice day!

[Author]

Posts