Skip to content

    • Charting

    Charting

    Percentage

    Member
    in Charting

    Hi,

    I'm trying to create a card which tells when someone has marked all the documentation.

    I have created an ETL to count the Numerator & Denominator I also created a column for percentage which is showing correct see the picture below. The 1 is 100% and anything below it's shows 0.85 and so on. But when I use that column in my card it doesn't work correctly so I did it in the best mode

    SUM(`Numerator: Score`) / SUM(`Denominator: Score`)

    which is displaying the right %,

    Is there a way to display that 1% as documentation not completed?

    Score.PNG Score_1.PNG


    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Answers

    • Coach

      Hi @Hiraayub

      You can set your column format to be a percentage to multiply the number by 100. Click on the Column and select Format then choose Percentage.

      Screen Shot 2021-11-03 at 12.47.02 PM.png Screen Shot 2021-11-03 at 12.47.14 PM.png


      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      That I have already done @GrantSmith , the questions I have is there a way to display that 1% as documentation not completed?

    • Coach

      You can use a Beast Mode to calculate if it's complete or not and then return a string value for it:

      Name: Documentation Completed 

      1. CASE WHEN SUM(`Numerator: Score`) / SUM(`Denominator: Score`) < 1 THEN 'No' ELSE 'Yes' END
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      No display no result :(

    • Coach

      Do you have any filters in place? Will the data show up without that beast mode?

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      No, there is no filters.

      I just use a Gauges and made it work.


      Capture.PNG


    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories