I have below listed columns in the data.
Column 1 : Methods (Example: A1,A2…An)
Cloumn 2 : Status (Pass, Failed, In-Progress)
I want to plot a table with percentage of Methods with Status.
Like : A1 method has 10% failures
I Tried with nested query concept
Query A :
which gives total count of failures
Query B :
Which gives individual count with Status
But when I am trying to get the % using AsPercent function I am not getting the desired value.
Can you please help me in creating the Table Dash board for above criteria.