@July, you mentioned that last two expressions worked, so curious if you have validated the results and results meet expectations. if not, then may be you want to create an analysis with sample dataset using [Quick Sight Arena.] and ask question (NEW - QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community)
DeepakS
7
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Calculate Percent of Total (distinct_count) | 4 | 227 | August 8, 2025 | |
| To show % of Distinct count field -percentOfTotal (workaround ) | 3 | 1740 | October 25, 2022 | |
| Percent of Total | 1 | 225 | July 27, 2023 | |
| percentofTotal Calculation with Count Distinct | 1 | 43 | February 5, 2025 | |
| Calculated Field: How can I total a distinct count? | 3 | 458 | February 1, 2024 |