Calculation not showing in pivot table

hi all,

I am trying to get the failure rate percentage for each week, when I added the calculated field into my pivot table, it is not returning any data and just showing a blank, not sure what is wrong here.

current calculated field formula:
countIf(status, status = ‘broken’)/(countIf(status, status = ‘broken’)+countIf(status, status = ‘working’))

Failure rate

Hi @linna

welcome to QuickSight Community !!!.

Could you please change the literals to Init Caps as Broken , Working

countIf(status, status = ‘Broken’)/(countIf(status, status = ‘Broken’)+countIf(status, status = ‘Working’)).


it is working now, thank you!