All rows of calculated field are unavailable.

0

I am trying to get a value for a calculated filed. I can't see the error in the calculated field, but the values for calculated field are unavailable. I am using sum function on a field which is integer and contains only 0 and 1. The calculated field is like SUM({field}). Any ans on why we see unavailable values in all rows of Dataset,Thanks in advance.

AWS
ursravi
gefragt vor 2 Jahren717 Aufrufe
1 Antwort
1
Akzeptierte Antwort

Hi, @ursravi

Are you saying that the calculation field cannot be used on the dataset edit screen as shown below?

Enter image description here

This is by design.
Aggregate functions are only available during analysis and visualization

https://docs.aws.amazon.com/quicksight/latest/user/calculated-field-aggregations.html

It can be used for visual display on analysis and dashboard screens.

profile picture
EXPERTE
iwasa
beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen