Hi All,
I want to show the success rate over time (by day) of actions that either passed, failed or were excluded. Exclusions will result in 0's for both fail_count and pass_count as they won't be included in the calculation.
I currently have my data set up like this (SS #1) — where for a particular day (May 30, 2024) there were a total of 88 actions and out of those 88 actions there were 24 that "passed" (SS #2) and 64 that "failed" (SS #3)
SS #1
SS #2
SS #3
What i want to do is display the success rate for this day — so Pass / (Pass + Fail) or 24 / (24+64)
But when i create a beast mode (SS #4) for this it shows as 0% (SS #5) for some reason. I'm not sure what I'm doing wrong here or if there is a better way to go about doing this. Any help is appreciated.
SS #4
SS #5
*** The bar graph is being Graphed by Day