Hi @tdr_Dinesh ,
Step 1: Please create a level metric aggregated at total and call that as grand total.
Step 2: Create two metrics, one for the Audit status Pass and another for Audit status Fail.
Step 3: Create a calculation between the 3 metrics: (Pass_Count + Fail_Count) / Grand_Total.
In order to rename the null, you can either create a case statement to replace the null with the choice of text or use ifnull function and create a calculated field.
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
Thanks,
Naveen