user07319 Member

Comments

  • Found that my dates are not UTC but (GMT+0) format. What is the best way to convert to UTC?
  • I have noticed that after 5 PM PST, all my cards are blank. I need to show all data for the current day. I am not sure why the cards are blank after this time of day
  • Looks like that helped MINUTE(TIMEDIFF(`FTechStartTime`,`ChatTime`)) Graph looks much better
  • OK, got it. I removed it and now the dates are working like it should. Thanks for the help
  • I am currently using workstation to import from a MSSQL database. The Transforms -> Shift Date Timezone has been set to UTC-07:00. This was setup a while ago. The dates are entered in the data base via UTC date. We need to view the dates in Mountain Time.
  • I'm pulling sql data in to domo, I've switched my workbench data to do a replace instead of an append so it's fine on that end now. However, I have 6 tables that I'm creating a dataflow off of, and it is doing the same thing. I'm using redshift, and the queries I'm running work well, but every time it updates the dataflow,…