-
Roll up rows in table chart with similar fields
I have a dataset of brands and corresponding data. I would like to have any rows with the same ID and device to be summed up and in one row. I don't want to use ETL for this because there is another column that distinguishes these rows so they may need to be filtered separately at times. Thanks
-
Replace "No Data" with a 0 on Map Cards
How do I change a map to show a 0 instead of "No Data"? The only option I've been able to find is "Hide No Data Items", which is unusable. I couldn't find anything in the card settings, and I'm hoping it doesn't involve an ETL solution. Thanks!
-
Adding values to a custom chart
Hi, This one is a bit of a stinker - our organisation has limited the use of DDX bricks currently, and I need to build a risk matrix with set colouring in each square of a 5 x 5 matrix grid. Initially, the goal was to create a pivot table with cleverly hidden columns and colour rules, but as some values were 0, the colour…
-
Rename Legend Series in YoY
Can we add the ability to rename a legend in YoY chart to change the name of legend from 'This year', '1 year ago', etc to the actual year it reflects (2022, 2019, etc.)? This would make consuming the information faster so you don't have to think about the year and do the math in your head :) Thanks!
-
Smart Text for Field Data Labels
I would love to have the option to use Smart Text in the data labels for particular fields in a card, similar to how it works in card titles or descriptions. This would be especially useful for labeling measures in a drill path based on the dimension selected in the top layer and comparing to segments. For example, a user…
-
Numbers disappearing on bar charts with small bars
Hi, I have a dashboard with a Grouped and Stacked bar chart. Oftentimes when one of the bars is very small, the data label disappears and only shows when hovering over the bar or legend. Default: Hover: Ideally the data labels need to appear by default. No matter how much fiddling around with the chart properties I do I…
-
Broken Trend Chart With No Data
I am using a Monthly Trend chart, and because one month has no data, the line is broken and does not go to 0 connected. Is there a way to make the chart show 0 for the months that do not have data? I have tried beast mode, dataflow with a calendar dataset left outer join, and it does not resolve the problem for some…
-
Can't Graph by Month
I've merged two tables and used the following formula to make sure the date doesn't get converted to String The two tables joined successfully. But My chart doesn't let me Graph By - Month The Table format still shows as 'String' under the Date columns. What can I do maintain the dates as 'Date' format so that I can Group…
-
New 'Journey Visual' suggestion
In my random internet browsing adventures I've noticed that Tinder has released this visualization that their users are going nuts sharing that basically maps their consumer journey with their platform. This chart looks very "sankey esque", but it allows the journey to end and it allows more levels of detail. I can think…
-
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,…
-
Date Range Labels
I think it would be useful to change the labels (i.e. for previous week, 1 week ago) to show the date ranges that fall under the "previous week" since those automated date ranges of previous week and 1 week ago sound similar.
-
Is it possible to add hyperlinks into a Gantt Chart Y value?
Hi, As the title suggests, I have a Gantt chart of project timelines, and I want to be able to add a hyperlink to the Y value so that when clicked on, it takes you to the relevant project link. I have produced a beast mode that generates the URL format, but I'm unsure how to proceed and if it's possible. Best, Stuck
-
Quick Select Multiple Columns in "Select Column" ?
I am wondering if there is a way to choose multiple columns quickly when using "Select Columns" in an ETL. I do not mean using Add All Columns. We do not know SQL, and we have massive DataSets with a large amount of columns (50+), but only need a mix of about half & half between 2 Datasets. Having to scroll through &…
-
Line over BAR chart
Hi All, Hope you are doing well!.. I currently have a bar chart to show the this year inventory by Fiscal week... I want to have a line running over my bar chart that shows the inventory for the same time last year...Can you please let me know how to do that.. My beast mode for This year inventory count(distinct case when…
-
Vertical Symbol + Grouped Bar chart Question
Hi All, I am trying to create a vertical symbol +Grouped bar chart to show by Fiscal Month week to show the On order $ for this year and last year and the on order units for this year and last year... Following are the beast modes that I am using X-Axis: Fiscal month week -CONCAT(UPPER(`FISCAL_PERIOD_LABEL_SHORT`),'-WK ',…
-
How to build a sales by state US Heat Map DOMO CARD Drillable into different vendors (US MAP)
Hi everyone, Just wanted to check if there is an article that will help build a sales by state heatmap for US States (on US MAP) drillable into vendors... Thanks, Arun
-
Colour Rules while comparing two columns.
Hi Team, Your support is highly appreciated in advance. Could you please advise/suggest how to apply colour rules based upon dynamic targets in 'Line Grouped Bar Chart'? Thanks Rabia
-
Dashboard question
Hi, I'm new to Domo dashboard and want to know whether there's a way if you click on one bar in the bar chart it will switch the dashboard to a new dataset. Like here if I have a dataset that is the overall of the months(2010-Jan ~2010-Dec), and I have separate dataset with more detailed info about each month.. I want the…