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
demandé il y a 2 ans717 vues
1 réponse
1
Réponse acceptée

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
EXPERT
iwasa
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions