I want to replicate the following results in column 4:
The above is a Table visual in Quick Sight.
AdjustedDates is a calculated field
Names - a field with values repeated, hence aggregated as “Count Distinct”
Names-Present - a field with repeated values, hence aggregated as ‘Count Distinct’.
I want to calculate the percentage of students present compared to the total students on a date and add that to the Quick Sight table Visual, as shown above.
Please tell me how to do this.
Hi @priyagoel
You can achieve this using calculated fields.
In your analysis you can create a calculated field (Click on the Calculated Field to get into the calculated field editor )
Create the calculated field with the following formula. Give the calculated field a useful name (e.g. Presence Percent)
distinct_count({Names})/distinct_count({Names_Present})
Add it to your table visual and format the computation as a percent
Thankyou so much for your response. It worked.
Great! Can you mark it as a Solution for tracking?
