We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

Set up a measure of min(result) that does not further aggregate to Count/Sum

Closed

Hi,
How can I set up a measure of min(result) [possible data values for result are 0,1,2] without it being displayed as either a Count or Sum of the min(result)?
I’ve tried setting up a measure as follows
measures: [
{
uniqueName: “result”,
aggregation: “none”,
availableAggregations:[],
formula: “min(‘result’)”,
active: true,
// individual: “true”
},
]
 
or as
 
measures: [
{
uniqueName: “result”,
aggregation: “min”,
},
]
But even for a data set that contains only “0” values for the result, the displayed result in each cell is “1”, as a count of the min(result) values.  This is within an Angular 6 integration.

This question is now closed