RobSomers Coach 
-
Re: How to calculate a ratio like 2:1
@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 g…3 -
Re: Add formula syntax error
@AdamC Welcome to Domo and SQL! So your statement will look like this: case when `Column A` IN('ONEY','CMDU') then 45 else 30 end or case when `Column A` = 'ONEY' or `Column A` = 'CMDU' then 45 else …3 -
Re: Combining data into one pie chart
@louiswatson You can use the Add Constants tile in ETL. You'll add one tile per branch of your ETL and name the column the same for each one (Stage), and then for each constant, put the name of the s…4 -
Re: % Sold of Available Inventory (aka Sell-Through)
@chapman Not sure if this will work 100% or not, but it's a crazy idea I just had. In your ETL, after your join could you just do a formula that calculates for each row what the percentage is? Then i…1 -
Re: Period Over Period Calculation Challenges
@RocketMichael Is your dataset organized at day grain like your table? Or are you doing the aggregation in your card? If it's in your card, you're going to need to throw SUM around all your case when…3
