How to show total count and percentage of error records in a table?

[firdshai (Firdous)]

Hi,
I have created a data table visualization and I am taking count as metric. Now I want more columns where I wish to take error count and percentage as metric which will give me the count and percentage of the respective error count value for the rows. Kindly suggest if it can be possible.

[chrisronline (Chris Roberson)]

Hi @firdshai,

Can you elaborate more on your data? What do your mappings look like? I'm not sure what you mean when you say error count and percentage

[firdshai (Firdous)]

Hi,

I want to get total error count and its percentage.
Suppose I have 10 records in which 4 fails due to error to whom I am calling error records so this count and its equivalent percentage which will be 40%.