-
CY-PY calculation for a value within a column
The issue I am running in to is how to call out the value with in the column i want to find CY-PY variance. I am using the formula from Domo page on the topic. In that formula it only has use using a single column. How can I find that variance of one single value with in a column? SUM(CASE WHEN YEAR(`Activity_Date`) =…
-
beastmode help. Nuanced conversion rate.
I have a conversion metric that I use a beastmode to calculate it it's pretty straight forward. Rentals/Inquiries as can be seen below in the calc. sum(case when `unit_rented_c` = 'true' then 1 end)/count(`id`) Now what I am trying to do is take these inquiries that haven't yet converted to a 'unit rented', but are in a…
-
Creating a static column that doesn't interact with the date filter.
I am working with Google Ads Campaign data. I want my 'Campaign' column to display all the campaign names and not remove any names when the filter is adjusted. other metrics such as 'click through rate' I do want to be able to interact with the date filter. How can I take my 'Campaign' column and make it static, so it will…
-
is it possible to add a constant in front of values in a column by using a beastmode calc?
I have an 'id' column in a dataset these id's are long and ugly. There is a constant URL that I want to be able to put in front of each value and have the column display this URL constant, followed by the id's. So it is as follows: Constant: https://xxxxxxxxxx.sugarondemand.com/#Calls/ Plus ID:…
-
2 Different Date Data Sets
I have a problem where I need to match up 2 different data sets to show funnel. Create Date & Demo Date. I need to show this data by week number. A demo date can be weeks after the create date. Here is my example: Data set 1 Week Create Count 1 10 2 20 Data Set 2 Week Demo Count 1 3 2 8 How can I merge these data sets do I…
-
Understanding My Data... preventing duplicates after DataFusion and creating a Table in Analyzer
Hello, I'm new to Domo and working with data in general. I've managed to connect my data from Greenhouse (applicant tracking system). I have a LOT of data and have used DataFusion to combine my large sets of data. That has all worked fine. I'd like to create a few tables that can be updated in real time (Example: current…
-
Make Data Previews Sampled by default when editing drill layers in Analyzer
When I'm editing a drill layer on a card, Analyzer tends to be less responsive due the granularity and lack of filters in the drill. Often times I need to change the data preview from All Rows to a Sampled view so that navigate through Analyzer without a significant lag. It would be helpful if drill layers generated…
-
Color Rules for Chart Text
Would be super cool if we could have color rules for the data labels on charts.
-
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,…
-
Bring back the old Analyzer
Domo release an "enhancement" to the Analyzer by including a drop-down menu. This is quite buggy, so they should just revert back to the old Analyzer. I didn't hear of any issues with the previous Analyzer so lets vote to bring it back instead of this awful enhancement.
-
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…