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

Airwon
Airwon Member
edited June 2024 in Charting

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

image.png

SS #2

image.png

SS #3

image.png

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

image.png

SS #5

image.png

*** The bar graph is being Graphed by Day

Answers

  • Airwon
    Airwon Member

    This doesn't make sense to me.

    image.png image.png
  • MichelleH
    MichelleH Coach

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

  • Airwon
    Airwon Member

    @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
    Airwon Member

    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.

    image.png

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

Categories