-
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.
-
Surplus/Deficit Chart Tutorial
The shaded area of these the surplus/deficit chart allows a balance to be shown – either against a baseline or between two series. How to build in Analyzer: Select 'Bar' under 'Popular Charts' as the Chart Type Create Calculated Field named 'Positive Value': (CASE WHEN Value >0 THEN 'Surplus' ELSE 'Deficit' END) Create…
-
Spine Chart Tutorial
Spine charts split a single value into 2 contrasting components (e.g. Male/Female). How to build in Analyzer: Select 'Horizontal Bar' under 'Popular Charts' as the Chart Type Create Calculated Field named '-National Count' (CASE WHEN Gender = 'F' THEN -SUM(National Count) ELSE SUM(National Count) END) Drag '-National…
-
Bar Diverging Chart Tutorial
Diverging bar charts are a simple standard bar chart that can handle both negative and positive magnitude values. How to build in Analyzer: Select ‘Horizontal Bar’ under ‘Popular Charts’ as the Chart Type Drag ‘Profit’ from the Data pane into X-Axis Drag 'Product' from the Data pane into Y-Axis In Chart Properties,…
-
What is the best way to calculate?
So I'm using a grouped bar graph and am looking to try and calculate the difference between two of my columns that were created. My company calculates the average spread on loans broken down by lenders we use. I was able to separate those average spreads by product by adding the products to the 'series' drop-in at the top.…
-
Trying to Find the Top 10 part numbers by $'s for the year for each plant department.
I have a large table showing plant department and their part numbers with the quantity scraped / dollar amount scraped as the values. Is there a way to only show the top 10 part numbers by department in dollars? Trying to be able to always keep track of what top part numbers are being scraped. Thanks
-
Calculating Compound Annual Growth Rate
Hi, I am attempting to use beast mode to calculate the compound annual growth rate of HH AA% and P2+ AA% between the lowest and highest season year identifiers. Any ideas of how to do this? In a typical compound annual growth rate calculation we would utilize the values for both the most current period and the furthest…
-
Period Over Period Multi-Value cards zeroing out when user changes the date
Good afternoon, I have several Multi-Value cards displaying both month-over-month and year-over-year values. They work great as is - but the values change to zero when a user changes the date at the page level. Is this supposed to happen or a side-effect of shoddy card building? Thanks!
-
removing/modifying columns in charts has become difficult
Good afternoon, Recently, when columns are in charts, instead of the "x" icon appearing over the column name, when hovering over it, to remove the column from the chart, we now have to click an arrow and then click "remove". Since this change, myself and others in my organization have been having a very hard time removing…
-
Drill Path Visibility
It would be helpful to be able to see when a dataset has been used in a drill path and which cards have a drill path tied to them.
-
Created rounding function to show number in pivot table card
It seems in Domo - Pivot table there is no function to change the column value(number) rounding. e.g.: value under column 20,580,307 ===> display as 20,580k or 21M please vote it!!!
-
Printing Cards that are Longer than One Page
I know this has been brought up many times in the past and it appears that each relevant thread was closed without resolution. We need a way to be able to print or output a PDF or PPT of a card without it being cut off if it doesn't fit entirely on one page. Currently we have several reports that won't fit on a single page…
-
Hide/filter out cards on dashboard display
Hi, I was wondering if there was a way to hide cards from a dashboard under certain circumstances. For example if the data being filtered was a certain value, a specific card would disappear. This will be for clients to export dashboards to PPT and not need to clean up superfluous elements. In a similar vein, I'm also…