AS Coach

So close. Each possible output of your case statement needs to be the same data type. The word 'unassigned' is the issue here. Do you want it to say 'unassigned', or just not have a value? If you want it to say 'unassigned', that word needs to be in quotes like the other products are: Pick one of the two in brackets: CASE…

We have a few places in our instance where our sales and marketing department needs similar interaction. We gave them spreadsheets in a Windows folder that they're able to edit on their own, and we have Domo Workbench retrieving those files on a regular schedule. In other cases, we have loaded spreadsheets using the Excel…

What's your use case? Do you just want to make it easier for other users to update data and change columns easily for data that's used in Domo? I think the API should be able to handle that. On the other hand, the Excel plugin can do the same: export datasets to Excel, edit data and schemas, and reupload to Domo. You could…

@ST_-Superman-_ suggests basically what I was thinking. Something on the dataset that would be a quick toggle from a page filter. If that's a dataflow, or in the original datasource job, you'd have to decide, but not a beast mode.

You can mass delete cards, pages, dataflows, datasets, people, and groups, and you can mass migrate cards or mass share pages with people, but you can't mass reassign inputs in dataflows. Not through the tools available to the average user, anyway. You might be able to with a custom API or with the help of Domo support. I…

Looks like in your beast mode you're trying to either override the count function or set the value of the count with = syntax. Case statements won't work that way. It should be more like CASE WHEN `Created Date` = '2018-Q1' THEN 518 WHEN `Created Date` = '2018-Q2' THEN 1224 WHEN `Created Date` = '2018-Q3' THEN 1373 WHEN…

I think here you'd need a successfully configured intermediate step in order to specify the output dataset. So if you can't resolve the error on the prior step, you can't finalize the last step.

As far as chart rendering goes, I don't think Domo generally cares. They're just numbers. I agree, don't implement workbench just for data type changes. And making a dataflow to change datatypes is probably overkill. I avoid doing dataflows for just one or two minor things. If you're doing other prep work, then dataflows…

Try taking off the sort on the date. Because you've chosen the date and the monthy aggregation, the card should sort by date on its own and that might be complicating the aggregation groups.

What data transfer method are you using to pull from postgreSQL? Are you using the API connector in the Domo web interface? I'm not aware of a way to override datatype coming out of those APIs. Could you possibly use Workbench and an ODBC connection and DSN on that server to connect to your database? That would be pretty…

You're using Workbench to get the data, then? In the Workbench "Schema" menu there are options to rename destination columns as well as change column types (which, as you mentioned, you can also do directly in your queries). Pick decimal from that list if you haven't already tried that.

A lot of this control depends on data source, ownership, and access rights. Are you an admin? If so, you should be able to refresh anything, as long as you have access to the workbench job or the account credentials. If you're not, you'd need to own the dataset or have access to the account credentials in Domo. If you…

What does your beast mode look like? Likewise, what filters do you have in place? This looks like one booking per month per center.

Lol your last line. I'm unaware of a function for mode. I think you'd need a dataflow for that, unfortunately. This, and lots of other articles online, provide some alternatives to standard functions. http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/calculating-mean-median-and-mode-with-sq/

This article has a section called "Supported Country Codes" and contains the list of codes and names that the map cards will accept.

You can take a couple of routes here. One would be to create a CourseBuilder app that contains your video. You can upload MP4s or link to hosted videos like YouTube.

In the data, does each row describe a task completed (task id, task start time, task end time, employee who completed the task, etc)? Or is each row a summary of daily performance by employee (employee name, shift start time, shift end time, tasks created, hours worked, etc)? Mixing daily aggregations (employee hours…

It's quite possible your email is being sent to spam. Check there first and work with your IT group to see if the server gobbled it up before it got to you.

What tables are A and B? Try something closer to this I think. This will likely still need some corrections, based on your situation. SELECT a.* ,COUNT(b.*) as voluntary_count FROM a LEFT JOIN b on a.`OU` = b.`OU` and a.`Job Code` = b.`Job Code` and a.`Date`= b.`LAST_DATE_WORKED` and b.`Separation Category` = 'Voluntary'…

Hi again @Ashleigh I have seen similar problems but not this specific issue. I think it has to do with the browser caching some filters. Do you see the same problem when you restart your browser and/or force refresh (ctrl+F5) the page?

It's funny you mention that. I was looking at my team's scores the other day. I really don't see a rhyme or reason to the scoring methodology. I'm our Major Domo and lead the company in a couple of the profile scoring components, with 100% profile complete, and have a score of 79. My boss, who leads none of the components,…

If you want to view hourly production by employee, you need to get the employees assigned to the tasks. In order to do that, you have to know who works at what time and what time tasks were completed. In the absence of a common thread like employee_id, does the tasks dataset have a task completion date or other type of…

We haven't been given timelines but we've had it for a couple months, so my guess is it will become standard sooner rather than later. We have found a couple of bugs, so I'm sure there will be a few things for them to iron out before releasing from beta.

This is what we use for tenure in years: DATEDIFF(CURDATE(),`hire_date`)/365

Not sure if it's still in beta or not, but you do or will have the ability to turn off exporting using the custom roles feature in the admin settings: The above is the default participant access level. You could create/copy this role and remove the exporting capability. You can also change which role has the default…

Looks basically ok to me. Maybe try a case statement instead. CASE WHEN DATE_FORMAT(`birth_date`,'%m/%d') = DATE_FORMAT(CURRENT_DATE(), '%m/%d') THEN 'Yes' ELSE 'No' END If that doesn't work, replace the date logic with something like month(`birth_date`) = month(current_date()) and dayofmonth(`birth_date`) =…

I gave similar feedback to the product team quite some time ago and it unfortunately hasn't changed yet. I'm not aware of a workaround at this point.

Hi @mfaas If you're looking for a web-hosted connector that will reach into your local system automatically and retrieve files, you're going to be waiting a long time. I personally don't think you'll ever find that in the Domo interface. I think you would need a locally stored application like Workbench to do that. There's…

Options are limited unfortunately. You could run the output of the Redshift through a MySQL dataflow just to rename columns. You could try renaming all of your MySQL columns so they're all lowercase. That might be considered a best practice if you're mixing SQL engines. You could also try running through MySQL originally.…

As always, Oracle errors are super helpful... Do you have a function, procedure, cursor, variable, or similar object in your query? This looks to me like your query is looking for something that isn't defined before that object is called.