user03793 — Domo Community Forum

Comments

Thank you that worked!

in Changing 0 for null or blank value then filtering those out Comment by user03793 September 2017
Ahh you might be on to something here - 'Forecasting: Month' is the field that is set as YYYY/MM and it is set as a text/string.

in Changing Date format to YYYY/MM to exclude days as uploading Monthly data Comment by user03793 July 2017
Hi Ricardo, I appreciate your patience with me ? I just tested Date and Time - no luck. Here is a screen shot above what you asked for. Could I try using a beastmode? Any thoughts on what that should be. Cheers, Jocelyn

in Changing Date format to YYYY/MM to exclude days as uploading Monthly data Comment by user03793 July 2017
Hi Richardo, I pulled the data from a custom Salesforce field that is in the format of yyyy/mm (see screenshot) then I am combining the data through an ETL to another table and changing the column type from a text to a date (see screenshot). I wonder now if I should not be changing the column type in the ETL and instead…

in Changing Date format to YYYY/MM to exclude days as uploading Monthly data Comment by user03793 July 2017
Yes that is highlighted and selected.

in Changing Date format to YYYY/MM to exclude days as uploading Monthly data Comment by user03793 July 2017
Hi Ricardo, Thank you for the quick response. I am fairly new to Domo so I am not sure what you mean by date seperator? Cheers, Jocelyn

in Changing Date format to YYYY/MM to exclude days as uploading Monthly data Comment by user03793 July 2017