Indicater for number in columb

[Mis]

Hi, so I would like to show a number (11.4) of the column (the name can be anything, let's say Field3 for now)

Japan

2019

11.4

8.9

As an indicator on widget but it shows the count of the whole column which is 2, including N/A.

How do I present only "11.4" on the indicator?

thank you!

[irismaessen · Accepted solution]

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...

[Mis]

@irismaessen than you, i think it solved the issue 🙂 !