This should be a simple calculation but I don’t know how to do it. My dataset is like this:
And I simply want to calculate the mean of the “values” column. I’ve tried the “Group by” and “Statistics” modules but:
Group by: I put the “Groups” tag with “values” and “Type Based Aggregation” with “Number (long)” and “Mean”. But I get: “No aggregation column defined”. But I I define am aggreation column I don’t know how to select all the “values” data…
Statistics: I simply select “values” in “Options” tab nut when I run it I get the output statistics table empty.
Any idea? Thank you!