-
Grouping up columns to do a margin analysis
I am trying to match YTD net sales with YTD Cogs by product line to create a margin analysis in DOMO. I have the beastmodes calculating the correct YTD formulas but the columns are not on the same rows? I am not sure why but they are shifting duplicates of the rows downwards to show 2 different products per net sale and…
-
Export card to Excel using API
I have a card containing numerous beastmodes and I can export to Excel through the UI and maintain the look of the card as well as all the filters. Is it possible to do this same action through the API? From the documentation I only see the option to query datasets, which we have done extensively, but I would want to query…
-
Is there a way to retrieve or export cards data to csv using Domo API?
I have a page created with a number of cards. Is it possible to retrieve card data or export to a csv using the API? I know API allows to export datasets to csv, but I can't find a way to do the same for cards. If not possible, is there any workaround to set it up in Domo so I can only retrieve card data with the API and…
-
Image Cards - using SVG Files
I can't seem to upload an SVG image to put on my dashboard as a header. Is this not allowed?
-
Is it possible to build a map at the Census tract level?
I'm looking to visualize some data set at the Census tract level, but can't seem to find a card or app that does this. Is this possible? If so, what are my options here?
-
Customize dashboard export?
Hi, is there any way to customize my PDF or PPT exports of my dashboard? I would like to remove the title of the dashboard from the top of every slide, as well as the filters at the bottom. Also, if there's any way to customize the first title slide that would be great. Thank you.
-
Can't add an existing card
I'm pretty new to Domo so I can't tell if this is a bug, permissions issue, or something else. I added some data, created a card, and was trying to add the card to a dashboard, but keep getting a spinning circle when I try to add that card. I can't even view any cards either - I get the same spinning circle. When the…
-
Domo Campaign - Add entire Domo Page into the campaign template
For the Domo campaign feature, domo provides the ability to add cards to the campaign template and we can customize and arrange cards based on our needs, But here we are not able to add the entire Domo Page/Story into the campaign template, it would be very helpful and reduce lots of work of rebuilding the same type of…
-
Trying to Count the number of Appointments in my data
I feel like this should be simple but I'm struggling with how to write the beast mode to where I get a whole number and not an average. I'm trying to count the total number of appointments in my sales data. This is what I've written: Count(`Bay Text`)/(COUNT(DISTINCT`Invoice #`)) I've attached a photo showing what the data…
-
Count function on a column to get total for two areas
I am trying to do a function to give me two number totals for locations by product line. The item number is a sublevel of the product line and I want to see how many of: for example 'Electric Cooktops' are in the red section and how many are in the green section. It might be an aggregation problem but the rank and window/…
-
Trying to get card that shows the row count that is shown in the data warehouse
I am using the Domo governance dataset to get the total row count, but the total is way higher than what is shown on our data warehouse page.
-
Add option for warning when Limit Rows field is exceeded.
If a card's data exceeds the default number of rows, it displays a warning, "WARNING! Not all of the data is shown." It's now possible to use the Limit Rows field in the Analyzer to increase the number of rows a card can display from the default 25k, but if this manual limit is exceeded there is no longer a warning on the…
-
Table Date Range Field Drop Down
The table Date Range option should not be fixed on the first Date field in the table. The drop down should be functional regardless of the fields in the table. Currently, the first date field is used for the date grain. This limits functionality and flexibility in reporting. You can only select the date range field when no…
-
Calculating Headcount based on Labor Hour Report
I am trying to get a HC for each department from our labor hour reporting data. I was going to use a count function by employee name to be able to pull the number of workers for each department. The challenge is for example: Date Employee Department 10/12 Jon Fabrication 10/13 Jon Fabrication How would I eliminate the…
-
How to append Doc cards with XLS data?
I have several Doc cards with XLS data inside them. I'm trying to find a way to combine these Doc cards' data by just appending them. Is there a way to do this in Domo, or perhaps even a third-party system?
-
Drill Down / Filter interaction
On a dashboard with multiple cards, it would be nice to have the functionality of being able to drill into a certain card and simultaneously filtering others by the column you're drilling into. Ex I have a card with multiple projects and a card with the financial information of all the projects, I can drill into the…
-
Can I display data in Kanban Board format or would I have better luck finding a unicorn?
More and more I am getting asked if there is a way to create a card/report where the data is displayed in a Board format (basically, vertical columns with activities slotted into the respective column). Looking for a creative, "elegant" solution....really surprised there doesn't appear to be a Card Option to create this…
-
Domo performance
Has anyone else noticed that lately Domo is incredibly slow? I've been trying to reduce dataset size, but even editing cards, it takes 30 seconds to 1 minute just to open the analyzer. I've also noticed that data sometimes doesn't change when I edit the card, but when I save, close, and reopen, then the data changes. Also…
-
Mass dataset change on duplicated cards
I was using one dataset to create all of my dashboards and cards, but I had to split it up into smaller datasets for performance. Now I need to duplicate all of the dashboards with duplicated cards and change the dataset on each one. I would like to see a way to change selected cards to a new dataset. I saw the post about…
-
Symbol Bump Chart Tutorial
Bump charts are effective for showing changing rankings across multiple dates. For large datasets, consider grouping lines using colour and symbols. How Select 'Symbol Line' under 'Line' as the Chart Type Create Calculated Field named 'First name only label': CASE WHEN Year T = MIN(Year T) OVER(PARTITION BY Name) THEN Name…
-
Top 5 Selections within 7 day Rolling Period
I'm creating a dashboard to track complaints filed against a facility. Each record in my dataset is assigned to a unique ID. Each unique record displays 1 "topic" they selected. The "topic" is the reason for their complaint. I need to find the Top 5 Topics selected on each ROLLING 7 day period. So today's 7 day period…
-
Bar Diverging Stacked Chart Tutorial
Diverging stacked bar charts, aka Likert scales, are perfect for presenting survey or questionnaire results that involve sentiment (eg disagree, neutral, agreed). How to build in Domo 1. Start in Magic ETL: Survey Dataset: Input tool: Survey dataset Group By Tile: Select what columns identify the grouping: Age Group Name a…
-
Symbol Proportional Ordered
Symbol Proportional Ordered charts when there are big variations between values and/or seeing fine differences between data is not so important. How to build in Analyzer: Select 'Scatterplot' under 'Popular Charts' as the Chart Type Create Calculated Field named 'Dummy Field': 1 Drag 'Sales Dollars' to X-Axis Drag 'Dummy…
-
Circles Timeline Tutorial
Circles timelines are good for showing discrete values of varying size across multiple categories (eg earthquakes by continent) How to build in Analyzer: Select 'Scatterplot' under 'Popular Charts' as the Chart Type Create Calculated Field named 'Dummy Field': 1 Drag 'Date' to X-Axis Drag 'Dummy Field' into 'Y Axis' Drag…
-
Seismogram Tutorial
Another alternative to the circle timeline, the seismogram is good for showing series where there are big variations in the data. How to build in Analyzer: Select 'Bar' under 'Popular Charts' as the Chart Type Create Calculated Field named '-Sales'Sales/2 Drag '-Sales' into 'X-Axis' Drag '-Sales' into 'Series' Turn on…
-
Have drill path point to separate card rather than under the same card
This has been asked several times in the past but all were closed. It'd be nice and assist with governance / maintenance to allow us to point drill paths to the same card so that the logic and visualization exists in a single location and is easier to find if I'm using the same visualization as a drill path.