RGranada Contributor

• Activity
• Posts21
• Comments381

• Re: MID Function

  RGranada

  August 2017
  Hi, If your are refering to BeastModes, there's SUBSTRING. Usage : SUBSTRING(String,Start,Lenght) / SUBSTRING('Employee Name',1,3) Some more info can be found here : http://knowledge.d…
  1

• Re: YOY calculations - DOMO recommended formulas not working

  RGranada

  July 2017
  Hi, Try it like this: Case When year(`FULL_DATE`) = year(curdate()) then 'This Year' When year(`FULL_DATE`) = year(curdate())-1 then 'Last Year' End Hope it helps.
  1

• Re: Changing Date format to YYYY/MM to exclude days as uploading Monthly data

  RGranada

  July 2017
  I think there is no reason not to work, maybe tre date/time instead of date... Can you take a screen shot of the upper area on your analyzer (i am sending an example)?
  1

• Re: Changing Date format to YYYY/MM to exclude days as uploading Monthly data

  RGranada

  July 2017
  Anyhow i can't replicate your behavior (only by turning the date button off) even if my x axis is a non datetime field i can see the date controls...
  1

• Re: Changing Date format to YYYY/MM to exclude days as uploading Monthly data

  RGranada

  July 2017
  Ok So, i think your x axis field isn't a proper datetime field... Is it database field or a Beastmode (can't tell in your screen shoot)? If it's a database field please show me it'…
  1

Next