user000253 Member

Comments

  • Hi @GrantSmith Thank you. I'm not sure I fully understand what you mean give it a numerical value? This is my Beast Mode for the custom bins: CASE WHEN CEILING(`Process Temperature (DegC)`)<= 0 THEN '-20-0' WHEN CEILING(`Process Temperature (DegC)`)<= 20 THEN '0-20' WHEN CEILING(`Process Temperature (DegC)`)<= 40 THEN…
  • Hi @GrantSmith thank you very much. I have managed to do the custom bins in beast mode. The only thing now is I can't get the sorting fixed. It's taking 100-110 group etc before 20-30. Any ideas on how to fix this? Thanks, your help is much appreciated.
  • Hi @GrantSmith thank you very much. I have managed to do the custom bins in beast mode. The only thing now is I can't get the sorting fixed. It's taking 100-110 group etc before 20-30. Any ideas on how to fix this? Thanks, your help is much appreciated.
  • Hi @GrantSmith thank you this is very helpful. By process my data do you mean to do this offline as in Excel? Or is there a function in DOMO that I can add columns and make both datasets have the same? As it stands Dataset 1 has 20 columns and dataset 2 only 3 (year, country, amount). Thanks