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
posta 2 anni fa717 visualizzazioni
1 Risposta
1
Risposta accettata

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
ESPERTO
iwasa
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande