-
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…
-
Custom Format 1 Line on a Multi-Line graph with dash or area
I would love the ability in the Color formatting to be able to make one of the lines in a series be highlighted by making it either dotted (vs solid) or thicker or better year change to area. As far as I can tell you can only change all lines and not a specific one, or just change the color of specific ones. An example of…
-
Problem with SQL for WordCloud Chart
Hi all! So, I am trying to run SQL code using these instructions https://domohelp.domo.com/hc/en-us/articles/360042925094-Word-Cloud-Chart When I am at step 9 and trying to run this code CALL word_cloud('nuvaira_patientlogreport_recursive', '`Notes`' , 'y','y' ); It gives me an error 'Invalid. Whoops! Something went…
-
Removing sort symbol from graph
Is there any way to remove the sort symbol from view? It can be obstructive when looking at the axis numbers. I can't find anything in 'Chart Properties' to disable it.
-
Please I need help with setting up a retention chart
Hi Domo gurus. I'm trying to create a "line + grouped bar chart" similar to the ones attached below. My goal is to create a chart that shows monthly cohorts of users who have made '100 api calls" and showing x% who returned to make other 100 api calls at the interval: 31 - 60 days, 61 - 90days, 91 - 120days, 121 - 150days.…
-
Help with Quarter Beast Mode Please`
Hello Community, I have a beast mode that is working for my purposes when reporting on the fiscal quarter in total. What I need to do next is show in a bar chart each month in the current fiscal quarter and the calculated currency value for each month. This dataset is coming from Salesforce and is from the opportunity…
-
YOY & Net diff Beatmode calc
I have kind of a unique YOY period that I am trying to create a report around. I am taking counts of leads that come through different marketing 'Marketing Sources', and only looking at the past 15 day window for each. This is straight forward. Take the counts for each source in the `Marketing Source` columns and use the…
-
How to custom name data series in legend?
I'm looking to name each series its own custom label, take a look: So for example, I want to change the top label to "Point - Tree - Batch", the second label to "Point - Tree - Manual", the third to "Linear - Curb and gutter - Manual", and so on... a custom label for each of the eight series. Can anyone help? Thank you.
-
Sorting-Histogram Text
I have created a histogram chart with custom bins. The value is "text" and the sorting is off see below. How can I fix this?
-
Custom graphics for gauge charts?
Is there any way to customize gauge charts with a custom background, OR, better yet, with svg custom graphics for certain elements of the gauge (Like we can do with map charts)? I'd settle for a way to overlay a gauge on a custom background but right now it seems I can only customize a background to a color, not an…
-
Drilling between custom charts
Hello, I'm trying to make a tool using custom charts for our building, but I'm not sure about the feasibility of my design idea. Essentially, I'm trying to recreate the drill down process to Zip Code shown in this DOMO video: https://www.youtube.com/watch?v=UUZ_RvKX8O8&ab_channel=Domo, but instead using custom maps of our…
-
Default is reverse legend on a bar chart
I think it seems a bit odd that the default on a bar chart shows the legend upside down. I realize there is an option to reverse the legend order, but I don't know why the default is to have the legend upside down? My idea is for the legend to follow the same order as the bar chart and you can select to reverse them as…