-
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…
-
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 -…
-
Hyperlink Capabilities in Charts and Graphics
This stems from a design idea I had when creating a Gantt chart to track multiple features of an epic using project data. I was looking to add to my Gantt chart the ability to make the "ITEM" field hyperlinkable so that users can visualise the project timeline and click on the Y-axis value of the project name and be able…
-
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,…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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 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…
-
Domo Campaign - Add entire Domo Page into the campaign template
For the Domo campaign feature, domo provides the ability to add cards to the campaign template and we can customize and arrange cards based on our needs, But here we are not able to add the entire Domo Page/Story into the campaign template, it would be very helpful and reduce lots of work of rebuilding the same type of…
-
Line chart - 'Fill Between' settings
Currently line charts have the ability to have fill under a single line - but this fill option is pretty basic, and will simply color underneath the existing line to some unknown, negative value. It would be far more useful if the 'fill under the line' feature had a few more settings. In particular: fill between two lines…
-
Allow for y-axis scaling on 100% stacked bar
There are occasions when the data that I am looking at doesn't vary much until the top of a chart. Including the entire chart can then make it difficult to differentiate between the changes of a single or multiple bars. It would be helpful to isolate these values by allowing the y-axis of a 100% stacked bar chart to take…