Skip to content

    • Charting

    Charting

    How to calculate a ratio like 2:1

    Member
    in Charting

    Hello, been looking at this one and cannot see how to make the calculation in a ETL or Beast Mode.

    What I am trying to achieve is a ratio or products sold, for example we sell 2 used and 1 new i want to display a ratio of 2:1.

    Is this possible?

    In my data i have the following available:

    1) N/U = Text value of New or Used per product sold

    2) New = if new then 1, all other values 0

    3) Used = if new then 1, all other values 0

    So i can get the total products sold, total new and total used sold but cannot seem to work out how to display it how i need/want it to display.

    Any help will be appreciated.

    Thanks

    Rob

    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

    Best Answers

    • Coach
      Answer ✓

      You can use the formula tile and the concatenate function to build your ratio string like this:

      1. CONCAT(`Usedfield`,':',`Newfield`)

      This would build your string.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Coach
      Answer ✓

      @robdmitchell Also to build on what @MarkSnodgrass posted, if you have unusual ratios (216:81), then you could do the following:

      CONCAT(SUM('UsedField')/SUM('NewField'),' : ','1')

      This would always give you the number of used for one new.

      **Was this post helpful? Click Agree or Like below**

      **Did this solve your problem? Accept it as a solution!**

    • Coach
      Answer ✓

      @robdmitchell Yes, use the ROUND() function on your division in the beast mode:

      ROUND(SUM('U')/(SUM('N'),2)

      **Was this post helpful? Click Agree or Like below**

      **Did this solve your problem? Accept it as a solution!**

    Answers

    • Coach
      Answer ✓

      You can use the formula tile and the concatenate function to build your ratio string like this:

      1. CONCAT(`Usedfield`,':',`Newfield`)

      This would build your string.

      **Check out my Domo Tips & Tricks Videos

      **Make sure to <3 any users posts that helped you.
      **Please mark as accepted the ones who solved your issue.
    • Coach
      Answer ✓

      @robdmitchell Also to build on what @MarkSnodgrass posted, if you have unusual ratios (216:81), then you could do the following:

      CONCAT(SUM('UsedField')/SUM('NewField'),' : ','1')

      This would always give you the number of used for one new.

      **Was this post helpful? Click Agree or Like below**

      **Did this solve your problem? Accept it as a solution!**

    • Member

      Tip Top, this worked a treat. @RobSomers, have applied the formula in beast mode, is there a way i can reduce to just 2 decimal places, looks like 9.604651162790697:1

    • Coach
      Answer ✓

      @robdmitchell Yes, use the ROUND() function on your division in the beast mode:

      ROUND(SUM('U')/(SUM('N'),2)

      **Was this post helpful? Click Agree or Like below**

      **Did this solve your problem? Accept it as a solution!**

    • Member

      Legend, thanks for that, have a great rest of the week.

    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