quinnj Domo Employee

Where are you entering the "YYYYMMDDHHMMSSfff" value to parse the dates? I'm not sure I'm aware of a place in Workbench to specify how a date should be parsed. As you noted, this is fairly straightforward to accomplish in a DataFlow, so that's probably the route I would take.

Definitely! You just have to drag the column that you're aggregating up to the "Sorting" box in the top left of the card buliding interface. You then have the option to say whether it should be sorted ascending or descending and how to aggregate the column being sorted. Here's a link to the help center article…

I think I've seen this before. I think it's pretty harmless. There may be some kind of miscommunication between when the datasource was uploaded from Workbench and it's "last updated date". It might be worth reaching out to Domo Support about and having the product team look into your specific case and see if there's…

If the files are being dumped in an FTP folder, you could leverage some of our beta connectors that can connect to FTP. I believe the CSV-SFTP connector is currently available for the public; we also have an Excel-SFTP and another CSV-SFTP that has more advanced configuration settings. Feel free to reach out to your…

Hey @Mackenzie, Sounds like an interesting use-case. Could you explain a little bit more the two datasets and why you're trying to join them together? Typically we have at least a date column we can match on. Currently, there isn't a way to get a unique identifier for rows in Magic ETL. It's definitely possible in a…

A few different thoughts here: * From the Data Center, you can hover over the "rows/columns" for a dataset and a card will pop up with column names + generic types (i.e. "text", "numeric", "dates") * If you open up a DataFusion (Data Center => click on the little down arrow on the "New DataSet" button, then click "Combine…

Hey @BSK, I'm guessing you're using different logins for the different Workbench servers? If you are able to use the same logins, the different Workbench instances should be able to see jobs created on the other. How it works is when a user creates a Workbench job, that job is actually saved to the Domo instance, tied to…

Hey @Jim_Medina, I like to use a simple trick to accomplish this using the NOAA Weather connector. As you know, DataFlows can be set to run when any of their datasources update. An easy way to "schedule" a DataFlow to run at a specific time is to setup a "dummy" datasource that will update at the time you'd like the…

Sure thing. The basic idea is to wrap your cell content in a 100% heigh/100% width div to take care of the background color. The following shows an example of doing a red background: CONCAT('<div style="background-color:#fcbcb7; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">', 'Red Conditional Format',…

You can chain Join actions direclty.

Yes, you can join multiple tables in Magic ETL. This would involve joining one table at a time, using the "Join Data" transform 4 times in a row. You would progressively build up the final dataset by joining the tables one at a time. Alternatively, this is also possible using a DataFlow and doing a JOIN or LEFT JOIN in…

@at8808, The easiest way to do this is to use a Sumo Card. It allows you to set conditional formatting on cell values. See the help center article for reference: http://wiki.domo.com/confluence/pages/viewpage.action?pageId=44827302 A more involved alternative solution would utilize custom Beast Mode calculcations where we…

As far as I understand, you can *create* Alerts on cards, but you can't make someone else *follow* that Alert. Luckily, if the Alerts are already created, all it takes it navigating to a card and clicking "Follow" on the Alerts that have been created. Alternatively, it might make sense to have the CEO let you login as them…

Hey @SLamba, A few things to think about, assuming you are using a MySQL DataFlow: - Using indexes is absolutely critical to getting good performance with MySQL dataflows; I make it a best practice to write out all the steps/transforms I'll need in my DataFlow and then go back and add an index for each column I'm joining…

@kvallee, Yes, the current process involves contacting Domo Support to have them setup "blank" custom GA connectors that you can then configure yourself. You can even request they setup as many blank instances as you think you may need. I would suggest going down this route until the functionality is tested well-enough to…

Hi @wadecourtney, Currently there is nothing in Domo itself that allows scheduled access to Domo data or transfer to other services. There exist, however, new tools that are currently in "beta mode" that allow for programmatic access to Domo data and that could be leveraged for downloading data from Domo and uploaded to…

@MReznick, A general design theme of Domo is to appropriately manipulate data at the latest stage possible. This generally requires doing less work upfront in the ETL process and allows greater flexibility at the actual card-building level. Currently, there doesn't seem to be an easy way to filter data in Magic ETL, but it…

@yoshidadaisu01, great writeup! Your setup is actually very common from my own experience implementing new clients in Domo. With regards to indexes, hopefully this helps clarify: * No indexes are ever created automatically on datasets/columns in MySQL DataFlows * With the "ALTER TABLE table ADD INDEX (`column`);" syntax,…

@snchilagani, as long as the column names are all the same, I don't believe you should lose any Beast Mode formulas set up for cards. In my experience, when you choose to "Switch Cards to Another DataSet", it checks if all the columns match between the datasets, and as long as they do, the Beast Modes are copied over. Do…

Hmmm, I just tried a few examples and got some interesting results. On a card that is set to "Last 30 Days", I said to export and it gave me the data by date for *all-time* (i.e. back through 2012 for this particular dataset). I then set it to a specific date range (07/01/2015 - 07/31/2015) and exported and it gave me the…

@gush, the error here happens when Workbench is trying to read an excel file column that is supposed to be of the "DOUBLE" type (i.e. decimal number), but it doesn't quite conform to the right format. Sometimes there may be other characters that are in a cell, or even an error code of some sort that throws off the column…

Ah, I see. I assumed this was Workbench related since you posted in the "Workbench" forum here. Yes, when you go to create a card and add the datasource that way, it is using the Domo Excel Connector, which currently doesn't support .xlsm. You can download Workbench from within Domo by going to your Domo instance, then in…

@WHM, that's unfortunate. I think I've heard of issues in terms of permissions that differ between the Workbench application vs. the service (which is what executes the command-line job). At this point, it's probably most efficient to contact Domo Support. You can reach them at the following url https://support.domo.com/.…

Hey @HelenOBrien, Not sure why you'd be having trouble uploading an *.xlsm file through Workbench since it supports that kind of file. Is there anything special/unique about the file or its formatting? If you'd feel comfortable, you could private message me a copy of the file and that may help me figure out what's going…

Ah, I see. Yes, that certainly makes sense. One option then would be to change how we aggregate the "Account Value". Once we add it as a metric column to our card, instead of using "SUM", we could use "MIN" or "MAX". We're not actually trying to get a minimum or maximum value, because all the "Account Value"s should be the…

@Francisco, also note that if it's just a column or two that are being read as text, often you can do a simple beast mode to convert it to a number. Such as: `column_being_read_as_text` + 0 This implicitly converts the `column_being_read_as_text` column to a number to add 0, the result also being a number.

Can you share an example of the file perhaps? (make sure to obfuscate any sensitive data) I've heard of people having trouble uploading excel files when there are special characters in the column names. Perhaps that's what you're running into here.

Hey @Moccs, I'd second @zcameron's suggestion of using DATE_SUB, but you may also want to take a more general approach. A few thoughts: * If your Domo instance is set to a certain timezone, then datetime values will automatically be shifted according to the timezone offset of the instance to UTC * You may consider using a…

Hey @ucstevenfu, I actually don't think you need to do any kind of transform on the data, if I understand what you're looking for correctly. At the card-level itself, we have the ability to do just the kind of aggregation you're talking about. For example, you could create a simple bar chart and put the "Account Name" as…

Currently it's not possible to have a DataFusion dataset as an input to Magic ETL. The reasoning, without getting to technical, is that a DataFusion is essentially only creating a view or "description" of how datasets should be joined, without actually running any calculations or physically creating a new dataset. When a…