-
Maps with non-numeric data
Hello Domo people, We have a project that wants to display string data on the world map but was surprised to find that it can only display numeric data. Is there some way to allow these maps to show non-numeric data? This is the only documentation I could find on this topic:…
-
Card Summary Number not Matching Running Total Number
Having an issue getting a running total line's last value (90) to match up with the same value in the Summary Number (83) despite using the same Beast Mode calculation for both. Any thoughts as to why these wouldn't match up?
-
How do I create a poll in Domo?
See this article. Thanks!
-
Regression Analysis on Bar Chart
We started using the regression analysis on a bar chart and noticed that it only goes out one time period (month, quarter) but doesn't seem to work with year (which is a different issue). Does anyone know if there is a way for it to go our 2 or 3 time periods. This may be a feature request but wanted to check if there was…
-
Percent change in summary number
I have a case in which the customer is trying to get the percent change from month to month and this is the updated calculation that I created that works intermittently: (SUM(CASE WHEN MONTH(`Date`) = MONTH(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) THEN (`Cost`) END) - SUM(CASE WHEN MONTH(`Date`) = MONTH(DATE_SUB(CURDATE(),…
-
Add a Series in a Pie Chart
Hello, I am trying to add a 2nd series to my Pie chart card in DOMO. It is in the same data source. I do not see any option to add another series. My example is a pie chart for Pipeline data that reflects Revenue and Unit values for each slice. Perhaps this is a limitation, but I needed to ask. Thanks!
-
How do I label the legend on a Tree Map
I can't find a setting in chart properties to add a label to the legend on a tree map. Anyone know? Here's a screenshot of what I see: The "Total 821" always shows, and the items below the rule line show up on hover. I can't find out how to label what 821, 80, and 10% actually mean.
-
adding values to charts
I can see how to ad the values in the bar charts - but tis there a way to have the labels be in different places depending on the data line? anther item would be to change the color of one data label from another. For example, may wat the value at the bottom of a bar chart and want it white so it shows up and above a line…
-
How do I create a stacked bar chart?
Greetings, After choosing the Stacked Bar chart option in "Edit Card" mode. You can select "No Aggregation" on the SECOND y-axis variable to make that the field that slices the stacked bar. You can review this link for ideas on when it is best to use the stacked bar chart. See this article. Thanks!
-
How do I calculate an average retention rate
Greetings, I am trying to calculate an average retention rate in my card and the numbers don’t validate when I take an average. I know the sum is not the right thing to do, any help would be appreciated. Thanks!
-
Poor Format of Emailed Cards/Dashboards
Hi All, Does anyone else struggle with the suboptimal format of emailed reports when viewing on mobile? In particular, there is a lot of dead space at the top of the email. I feel like it discourages recipients from scrolling down and viewing the actual data contained in the report. Attached is an example. I thought that…
-
PPT Plug-In messed up x-axis (extra decimal places)
Hi I am toying with the PPT Plug-in for DOMO and found that for a card I downloaded via plug-in, the x-axis variable has an extra decimal place vs. integer on the DOMO website. For example, instead of 2, it shows 2.0. How do I fix it?
-
Secondary Axis - Domo Dojo
I was looking in the forums how to have two lines with very scattered values and put one of the lines as the second axis. I did not find anything in the forum but after trying all the options I found how to do it.
-
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 -…