Forum Discussion

Mis's avatar
Mis
Cloud Apps
11-17-2021
Solved

Indicater for number in columb

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!

Elasticube
Windows
  • irismaessen's avatar
    irismaessen
    11-17-2021

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

2 Replies

Replies have been turned off for this discussion
  • irismaessen's avatar
    irismaessen
    Data Pipeline
    11-17-2021

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