-
How to count strings in a column containing a comma delimited list of strings in each row
Hello, I have a field in which each row contains a comma delimited list of strings. I'm trying to find a way to display how often each string appears in the dataset. For example, the column might be "City": Row 1 | New York,Boston,San Francisco Row 2 | Boston Row 3 | New York,San Diego Row 4 | New York,Topeka I like to…
-
Comparing year on year figures
Hi, I'm looking to compare yearly figures from ‘Contractor Completion’ from 2019-2023. We'd like to know the percentage change for YoY and comparison by month too. The flex table or line chart looks like a good way to show this. What would be the best way to do this?
-
DDX charts with html links in Community March Virtual Meetup (2023)
Hi, This question is for those who attended the Community March Virtual Meetup (2023) earlier today (Mar 16, 2023). In the demo they showed a chart which had bar charts, line charts, Text chart, etc and at the bottom were html links to link to another chart/dashboard. See attached. Anyone know which chart allows me to do…
-
Creating a Heat Map Based on Start and End Times
I have a data source that includes one row each for scheduled activities, with a column with the start date/time and end date/time (i.e. 2022-09-06T09:00:00 and 2022-09-06T13:00:00). What I need to produce is a heat map showing blocked out times in hour or half hour increments on a heat map, with the days of the week as…
-
Breakdown of Yes or No Values
I am looking to create a graph or table that shows a breakdown of who answered yes and who answered no in a specific state. E.x. in GA 100 people took the survey, 45 answered “Yes” and 55 answered “No” in FL 50 people took the survey, 20 answered “Yes” and 30 answered “No” What graph/table would you use to display this in…
-
Antithesis Filtering on Dashboard
Hi all, When filtering on a dashboard - traditionally, my process is to have a few filters at the top of the dashboard, which are my top-level generic page filters. This process works great for me, and it's standard across our dashboard offerings that our audience understands. I've now started building a dashboard where I…
-
Can we save / export the projection data as a dataset in Domo Analyzer Cards?
We have created a Domo Analyzer Card using "Multi-Period Projection" from the chart properties. It uses Linear Regression Recent Weighted and shows the projection in the UI. We need a dataset where all these projected datapoints will be saved. Any idea how to create this dataset or export it from the card?
-
Multiple Event Types on a Calendar Card
Hi all, I've been working on a release and defect calendar card and have encountered some limitations with the current calendar card - I've managed to map all defects onto the card with no problems; however, I want also to include a separate event type in the same calendar for a version release date. Effectively the story…
-
Multiple Events aligned on a single Calendar Card
Hi, As the title suggests, it would be good to be able to add more than one Event field and date field populating the same calendar card (even if they have different date fields) and to be able to control what the output of the data label on each day of a calendar looks like in a month view instead of having to force a…
-
How can I color the bar based on a beasmode not directly shown in the chart?
I am trying to color the 2nd (Appointments) bar based on the ratio (Appointments/Target) However, it does not seem possible via the Color under Chart Properties - Is there any other way?
-
Is there a way to force a column header to be blank?
When formatting a column "Data Label" in a table chart from the formatting drop down where you would format justification etc. - you are able to override the column name with more plain english. However, in some instances, I've wanted to override the column name with nothing, i.e. have a blank column header, especially if…
-
When uploading a custom chart an option to turn off the colour override
When using the custom chart feature and uploading a new visual to be used, a checkbox to turn off overriding colour would allow for so many more use cases of this feature. If we could create/upload an SVG file ourselves, in the same process, but upload it with the shape colours we want by simply having a checkbox during…
-
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…