This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Sisense generally expects there to be a form of aggregation applied in formulas. The default aggregation chosen is usually either COUNT() for (partially) non-numeric values or SUM() for numeric values. In this case, since you want to show a single value, probably you want to show the MAX(), AVG(), or MIN(), possibly appropriately filtered to exclude any rows with inappropriate values. If there is only one value, all three of those should work out to the same number...
Sisense generally expects there to be a form of aggregation applied in formulas. The default aggregation chosen is usually either COUNT() for (partially) non-numeric values or SUM() for numeric values. In this case, since you want to show a single value, probably you want to show the MAX(), AVG(), or MIN(), possibly appropriately filtered to exclude any rows with inappropriate values. If there is only one value, all three of those should work out to the same number...
