How to calculate a ratio like 2:1

robdmitchell
robdmitchell 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

Best Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

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

    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.
  • RobSomers
    RobSomers 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!**

  • RobSomers
    RobSomers 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

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

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

    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.
  • RobSomers
    RobSomers 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!**

  • robdmitchell
    robdmitchell 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

  • RobSomers
    RobSomers 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!**

  • robdmitchell
    robdmitchell Member

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

Categories