How do I get the % or Success rate to display properly on a bar chart?

Airwon

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

Airwon

This doesn't make sense to me.

MichelleH

@Airwon What does your raw data look like? Is it possible to have passes and failures in the same row?

Airwon

@MichelleH Every row is either a pass/fail/exclude. And it is not possible to have passes and failures on the same row.

You can see above on the 1st Screenshot that i have a pass_count and fail_count field. If the action resulted in a pass then the pass_count will be 1 and the fail_count will be 0. If there is a Exclude then both the pass_count and fail_count will be 0 — excluding it from the equation.

Airwon

Weird! So I brought the data in via Query (PSQL connector) and now both the card and beast mode work as expected! *** above i was using a federated connection.

So now my question is — why does it work via DB connector but not via federated connection? It's the same dataset…..