SeanPT Contributor

Comments

  • The heat map idea is great. That worked out really well. Thank you for the suggestion on that. I went with 15 minute blocks and it is some great data viz. On the timestamps, they are all 'local time' which is what I want. Of course in Workbench I flag them all as Central and in Domo I have central time zone selected. I…
    in I need help visualizing timestamps Comment by SeanPT December 2015
  • @magicdust - so far I'm doing it a couple of different ways. 1) Most of my data is coming in from MS SQL so when I run a workbench job that appends data I also write back to a log table I created to let me know which records were uploaded and when. 2) I parse the log files in C:\ProgramData\DomoWorkbench for the jobs…
    in Monitor Dataflow in Card Comment by SeanPT November 2015
  • I'll give a heat map a try. The time stamps represent when a sale was made, e.g. 11:15 am. With 37 million records, every minute from open to close is accounted for with at least a few thousand sales. I think to do the time as a heat map I'm going to have to group into 30min chunks. That Pareto is a great idea because…
    in I need help visualizing timestamps Comment by SeanPT November 2015
  • Thank you for these posts. I would love Domo to add a "just don't mess with my timestamps, ok?" button. We have restaurants across the country and the POS records everything in local time. As far as I'm concerned, local time is what I want. If I want to see how busy we are between 11 and 1 I want everyone's local 11 and 1.…
    in Timezone Settings - Need Assistance Comment by SeanPT November 2015
  • As far as I've been able to see, no. To be interactive, you have to be logged into your domo instance. I mean, you could do some iFrame stuff but people would still have to be logged in for that to work. You can do the publish as slide show thing and you can embed that but you don't really get the interactivity part of…
    in Publishing a dashboard to a website Comment by SeanPT November 2015
  • I've suggested we get a Domo connector for Domo so I can get data on my data. If they call it the Yo Dawg connector it will just make my day. For monitoring I use a combination of things, most importantly I've setup alerts on all my dataflows. That is critical for monitoring for me. (I guess I could also setup a rule to…
    in Monitor Dataflow in Card Comment by SeanPT November 2015
  • In TSQL you could use CASE on the column to search for the strings Pushing or Pulling and return just that string. But I'm not sure if you can use that with ODBC in WB3 or if you are even pulling from a TSQL table. Sorry if that isn't much help ?
    in Using MID function with Workbench 3? Comment by SeanPT September 2015
  • This is fantastic. I am trying this for the first time today and I'm using a field ImportTime for my lastvalue. I setup the initial variable using Edit Query Variables. ImportTime and a timestamp that would be before all my data. I then added a line to my query WHERE cs.[ImportTime] > '!{lastvalue:ImportTime}!' ORDER BY…
    in Appending Data Capture using Domo Workbench Comment by SeanPT September 2015
  • If you can get rid of the % out of the value you then you can cast it as a number. Then take that number and just divide by 100. There is your decimal value. So what about (going step by step) TRIM(TRAILING '%' FROM 'your_column') = 14 CAST((TRIM(TRAILING '%' FROM 'your_column')) AS DECIMAL(2,2)) = 14.00 Finally --…
    in Changing a string to a number Comment by SeanPT September 2015
Default Avatar