-
DataSet API: Compressed payloads?
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
DataSet API: CSV options and alternatives
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
-
Finding the last non-zero value in each column
I've got a DataSet with several columsn. Each column stores a single statistic: TotalItems NewItems RepairItems There are many rows, each of which has each column along with data, location name and other values of interest. Here's the question: Sometimes rows have 0's that indicate 'no change'. What we're after is a chart…
-
Is there a trick to get a client with 'user' scope using the API?
I'm just trying out the API and can't create a client with data, dashboard, and user scope. If I leave out 'user', I can generate a client instance. I'm logged in as an Admin user. Is there some trick or setting that I need to know about? Thanks!
-
Editing DataSet settings broken?
Over the past few days I've noticed that it's no longer reiably possibe to edit settings for many DataSets. For example, when you set up an Excel import, you can configure the range of rows to import, etc. The source spreadsheet name, range options, schedule, etc. are no longer visible or editable. Having PDP enabled or…
-
Understanding PDP, DataSets, and DataFlows
I've finally had a look at PDP as I need to retrofit a page with dozens of cards to filter the data on display for specific users and user groups. When I'm learning something new, I usually read the docs, try it out, and make junky little sketches. If I can't make a sketch, I definitely don't understand what I'm looking…
-
Confused about Min/Max/Avg and calculated lines
Many of the bar and line chart types include Min/Max/Avg and calculated settings in the "Gridlines" property area. But, as far as I can figure, these settings don't apply to most of these card types. Or something. Many of our charts can benefit from chart-level ines, including min, max, mean, median, and goal. Is there a…
-
Calculating the average per day for a summary figure
I'm new to Beast Mode and have a problem I could use some help with. I've scanned through the docs, built a few simple Beast Modes and watched a few of the introductory videos. Put another way, I have no clue what I'm doing
-
Is there a way to change the labels in a legend?
Our different data sources don't always use identical column/field names. For example: AssemblyHour AssemblyHours On a chart type that displays a legend, like a bar chart, the label that appears is drawn from the measure's name. Is there a way to override this? Then we could, for example, make very instance of similar…
-
Displaying what controls bubble size on a bubble chart
I love bubble charts. People may need them explained once or twice, but then bubbles are just so great at packing interesting information into a big space. I've had a look, and I think I'm missing something obvious: How do you label what's controlling the bubble size? It's critical to know this when you're trying to…
-
What does "Lock Data Type" mean in Workbench 4?
I've found importing Excel datetime values a bit tricky and am using Workbench to fix glitches. The values are formatted in a way that works correctly on most columns, but some still come through as text. So I use the Schema tab to set the field type to DATETIME which seems to do the trick. I've noticed an attribute on the…
-
Importing datetime values from Excel without a transformation
We've got a bit of a toolchain between some of our data and Domo: Database --> Library --> Excel --> Workbench --> Domo According to the Domo Excel Connector docs, Domo can handle a bunch of date, time and datetime formats automatically: mm/dd/yy dd-month-yy weekday-month,dd,yyyy m m-dd hh:mm:ss PM hh:mm mm/dd/yy hh:mm PM…
-
How does Domo support slopegraphs?
Full disclosure: I'm really not so smart that I knew the name "slopegraph" without looking it up. It's a chart type that I've admired several times over the years at fivethirtyeight.com. It's about the most economically and easily interpretable chart type I can think of for showing relative and absolute change over time.…
-
Does Domo support dot plots?
I'm new to Domo and still getting acquainted with its features. I've been reviewing the amazing array of available chart types, but I'm not finding "dot plots". I don't mean scatter plots of bubble charts, I mean dot plots as an alternative to bars or stacked bars:…
-
Unable to reload/execute a DataSet from within Domo
New to Domo, enjoying it so far! I've got several DataSets coming into Domo either via Postgres pulls or via Excel pushes from Workbench. Today I added a new DataSet via Workbench and went into the Data Center to check it out. I noticed that over in Domo, a stack of my existing DataSets were marked as stale with a warning…
-
Is there an advantage to splitting a DataSet with a DataFlow over using a page/card filter?
We're using and learning Domo, and I'm checking out some alternatives as they come up. The Magic ETL DataFlow editor is slick. I'm not normall one for visual programming tools but, dang, that window is impressive. Here's my test setup. I've got a DataSet with about 220K rows. It lumps together data from a variety of…
-
Postgres Data Flows
I'm new to Domo and finding my way around, so apologies if I'm asking an obvious question. I've set up Postgres DataSets and they seem to work just fine. I've now noticed that there are SQL DataFlows based on either MySQL or Redshift (which is a fork of an old version of Postgres.) Is there any plan to support Postgres 9.x…
-
Does Domo support pyramid charts?
Still exploring Domo's chart types, and I'm not finding "pyramid" charts. I think that these were invented, or at the least popularized by, the US Census Bureau. They're commonly used to split some relevant measure by gender and age, like this example from…