quinnj

About

Username
quinnj
Joined
Visits
0
Last Active
Roles
Member, Domosapien
Points
254
Badges
0

Comments

  • 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 @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…
  • 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…
  • @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. 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…
  • 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…