AS Coach

If your data is by transaction, I'd first aggregate it to daily by whatever dimensions you need. Then do a "Date Operations" column to create a new data, taking your date column and adding negative days (like -7 for last week's data). Then add a join transform to join the "daily aggregate" and the "daily aggregate with…

Colors in KPI cards, like bar or line charts, are assigned by either the order of the column added to the card or the order of a value appearing in a particular column, but not the value in column itself. In other words, the vehicle type "Sedan" cannot by itself always be assigned to the color red, but if "Sedan" always…

Similar to McSQL, I've done the same thing but flattened: join the data on itself but shifted by a week (or month, or whatever the business need is), then output "Vists Last Period" as a new column next to "Visits This Period". Seemingly identical to the first dataset but with the new last period column. Then your % change…

The GA Page column may not be available through default reports with the default GA connector. Domo has a more advanced GA connector that is not turned on unless requested, but Support can get that spun up easily. Using the custom report option with the advanced GA connector you can build your own reports from a number of…

Whenever this happens to me I force-sort the values using a beast mode to override the default alphabetical sort. Do something like: CASE WHEN `stage_name` = 'Bullpen' THEN 1 WHEN `stage_name` = 'On-Deck' THEN 2 WHEN `stage_name` = '1st Base' THEN 3 WHEN `stage_name` = '2nd Base' THEN 4 WHEN `stage_name` = '3rd Base' THEN…

Errors you get in workbench for ODBC connections should be the errors returned from the database, not workbench, so you'd probably want to consult your ODBC driver docs or database docs for specifics. It could be something like: exec procedure_name (startdate,enddate); or call schema.procedure_name (startdate,enddate); or…

Are Hits/Visits/Pageviews values in a column, like "Traffic Metric Name"? Or are they separate metrics on the same table? If they are separate metrics then the only real series is the date, and that becomes the filter used in the drill. If they are values in a column and you're using that column as an additional series,…

Columns adjust automatically to fit either the screen or the column name, but can't be manually adjusted to a specific size (like 50 pixels). That Excel-like functionality doesn't exist. With one exception: when a column name is long and is truncated by default, you can turn that off or on by toggling the setting found by…

You're using the horizontal bar chart? Height percent corresponds to the amount of space each bar will take up compared to the amount of space it could potentiall fill, given an equal breakdown of space for each series bar. At 40 height percentage At 90: Over 100% and the bars start to overlap. Using the Fixed Bar Height…

No, not from a Sumo table. You could build out a regular table card and do it there, or create breakout cards and then "relate" them to your Sumo card so you can see other options and get there with one click.

Table cards (but not Sumo tables) can have drill paths. For example, we have a table card that shows revenue by product line. Below that is a drill table (if you click on a product line value) which shows revenue by rep. And if you click on rep, a new drill table is displayed that shows individual transactions. Each drill…

Individual datasets can be exported. So you can do one at a time, or you can use dataflows to merge them all into one (which you might want to do for reporting purposes anyway), and then export that merged dataset.

You should be able to just go back to the dataset in the datacenter and select your file (the same file updated) and load it again (in the first section, Select your Excel Data/Data Selected). Not in a new dataset, but reconfigure the existing dataset.

I've seen several approaches: * Build cards for each account and have an income statement page to display the "statement" in its entirety, broken down by collections. Charts to display trends but summary numbers to display current values. Obvious potential downside is the statement is pretty unusual for people used to…

That configuration option only helps with the organization of the data in your datacenter and the datawarehouse. It helps Domo pick datacenter logos and sets metadata but doesn't affect the underlying schema. Generic ODBC might be shorthand for any kind of structured database like an internal mySQL server connection,…

You're welcome

https://knowledge.domo.com/?cid=notebookcard https://knowledge.domo.com/?cid=addnotebookcard

The only options for font alteration are italics and bold. But the ability to change font sizes would be nice. Post the suggestion up on the ideas exchange board.

On the page you want to create the card, click on 'Add Card', then 'Design', and 'Image' will be a choice:

You can add a card called an image card which is just a simple photo. But you can't set it as a background for another card type. If you have adobe illustator you could whip up a domo app with a picture as a background and your choice of chart widgets to appear in front.

Haha! Deal.

You can add columns from other datets by joining them as another dataset to the dataflow you're working on. There isn't an easy way to search all columns of all datasets (a good idea), but you can hover over the 'Rows/Columns' section in the list of datasets in of the Datacenter, which will display all of the column names…

Lol. Small, unmarked bills, por favor. Keep in mind you'll need to use the same syntax when referencing spaced column names anywhere in your query, including the FROM and WHERE clauses. SELECT a."Customer Name" ,b."trx amount" FROM customers a JOIN transactions b ON a."customer id" = b."customer id"…

Looks like you might have the Redshift version of Dataflow. Is that right? Redshift uses double quotes to do the same thing. select "business email" from dataset

Not that I'm aware, but that would be a useful feature. Post it up on the Ideas Exchange!

For MySQL use the backtick character ` (not apostrophe- that creates a string) surrounding your column names. ie SELECT `trade show` ,`contact person` FROM my_data_flow That should also turn the name of your column light blue so you can tell that it worked.

The direct import from google sheets itself can't be edited that I'm aware, but you could pretty easily spin up a dataflow in Magic and rename those columns on a new dataset.

Domo has an API connector for Harvest, though it may not be publicly available yet. If that's the case, you may be able to get access to the beta version by contacting Support.

I think the axis labels have that option, but the data labels don't. At least not on this chart type. On the grouped bar chart type you can 'rotate' the data labels in data label settings. If you could go vertical here, you may end up running into the same problem but the labels might overlap from one series to the next…

There isn't a solution I'm aware of on the export side of things. I think the ability to inject HTML was more of an afterthough or happy accident, rather than a planned feature. Tables in general are not Domo's strong point, at least so far.