QuickSight Team, is it possible for calculated fields of the text type to display their actual content in a pivot table, rather than being limited to only “distinct count” and “count” aggregation options?
In tools like Power BI and Tableau, creating custom text metrics is straightforward. However, as QuickSight users, we have been requesting this very useful feature since 2021.
HI @MoYuan
Are you saying you can not add your calculated field of text type into the Dimension section?
What error do you get?
Regards,
Giri
Hello Giridhar, thank you for reaching out to me.
No, what I meant to say is that in the PIVOT TABLE, we can’t add a calculated field as a metric in text form. This is because we can only select aggregation options such as ‘distinct count’ or ‘count.’
For example, if my metric is IF value > 10 THEN 'Good' ELSE 'Bad'
, in the pivot table, this metric will only display the result as 1 (due to the count aggregation).
another example:
Hi @MoYuan,
I understand the request and why this could be a nice feature to have included. I’ll mark this as a feature request to promote visibility to the support team.
If you have any additional questions or comments to add, please let us know. Otherwise, if we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @MoYuan,
I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you!