-
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…
-
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…
-
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,…
-
Alerts in SPC charts
Good morning, Not so long ago, for the SPC charts there were alerts that trigger when the control chart rules were met I am not able to find that feature anymore when setting up the alert
-
Remove Scale Abbreviation in Comparative Gauge
Hi! I am trying to use a comparative gauge that is showing a value change where it is important to have the exact number (in thousands). Unfortunately, the gauge keeps abbreviating with the K for thousands. Is there a way to prevent this? I have tried every number formatting option I can find. Any ideas?
-
Row Combine
Hi everyone, I've asked a similar question before, but I'm struggling to understand how to best combine multiple rows into 1 while still combining the data from the existing columns using a ,. I have a list of students who are enrolled in a course and they share an OrgUnitIDand then have different times when they have…
-
DataCard Date Range and Dashboard Filtering
Each Department submits data on monthly basis for review by the Organizational Leadership each month. Each Department has their own dashboard and within each dashboard several DataCards. The DataCards might show data for the past month or could show a monthly value or a trend of data. The Date Range is specified within the…
-
Combining Disparate Data Sources on a Card
I know it's not possible to create a card that pulls in data from multiple databases unless you combine them with a dataflow / ETL. But I have a scenario where that approach doesn't make sense as the data is VERY different in structure. Basically, one database has detailed individual end-user records which I'm totaling…
-
Case statement in beast mode
Hi, I have five columns in the dataset named Product1, Product2, Product3, Product4, and Product5. I want to find out how many products have been sold in 1 transaction. All columns have value 'Y' and 'N'. To find out the combinations of 2 products bundle, I am using: (case when (`Product1` = 'Y' and `Product2` = 'Y') or…
-
Flex Table: Multiple change percent columns
I'm trying to build a flex table that can analyze both % change against the first value in my data as well as the penultimate value in my data. Flex table does not seem to have any functionality to allow different calculations of change percent for multiple columns. Any suggestions on what I might be missing? Thanks in…
-
Dynamic date range (last two quarters)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…
-
Dynamic date range (last two quarters)
HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two financial year quarters data. I am aware that there is an option in DOMO to get last two quarters data but this gives me incorrect results i.e if we are in May then this gives me nov - april data but what I need is oct 1st -…
-
highlight top defects
I have a dataset where I want to count how many times a distinct "defect alias" field appears and highlight the top 5 distinct ones. I.e. - Highlight the top 5 reoccurring defects. I tried to get a count, but doesn't work..
-
Period-Over-Period % Change in Multi-Value / Single Value Gauge
Hi all, Still new to DOMO (4~ months) so just learning the ropes. Please point me in the right direction if this is posted incorrectly or if im possibly not understanding something! I'm trying to accomplish a simple Period-over-Period % Change calculation and it looks like this is an ongoing question/problem and I…
-
DP22 - Using Beast Mode to Build Data Storytelling - Sales Pacing Graph
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case: We needed a way to display and estimate in real time how well our sales were pacing…
-
DP22 - Using Beast Mode to Build Data Storytelling - Adding Business Days
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case When evaluating different carriers for performance we needed a simplistic calculation…
-
DP22 - Using Beast Mode to Build Data Storytelling - Formatted Time Duration
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case We wanted a way to display how long an invoice took to process in a more human readable…
-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the wrong data), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this post…
-
Is there a way in Domo to show/hide columns in a table type of card ?
so I have a table card which has 10 total columns (i.e. column 1-10). I want to give an option on my end application (where I would embed my dashboard) to user to see only selected columns dynamically in this table. So a user can select that I don't want to see column 5 and column 8, so this table should hide those 2…
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this…
-
Build Top 3 Card
I have multiple contributors in my Db and I'd like to create a card where I can display who are the Top 3 contributors sorted by rank. I have tried using a dynamic text card and the adding the categories with the Text Macros but this solution won't work once I have more than 3 categories. Is setting the amount of rows…
-
Showing less time scale on line graph chart
Hi everyone, I would like to see more dates with this button. But I couldnt find where i could add button which i linked with a screen shot below. Thank you
-
Check which cards have 'Use fiscal calendar' checkmark ticked
One of our operation companies is evaluating if it should adopt regular calendar in lieu of current 5-4-4 fiscal calendar starting next year. Is there a more efficient way, other than manual checking, to identify which cards have ‘Use fiscal calendar’ ticked in Date Range? I don’t see such attribute in any Domo Governance…
-
How to reset dataset color rules?
I adjusted the name and data type for a column previous used to set dataset-level colors. Now my colors aren't working and when I try to reset them in the dataset, I get nothing but JS errors in the console. Is there a way to force the dataset to reset the colors without having to delete everything and start over? Thanks!