-
Chart Types Search in Analyzer
We keep getting more and more charts to utilize within Domo which is great but it's also more difficult to find the exact chart I'm looking for. It'd be great if there was a search bar for the different chart types within Analyzer.
-
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 find the difference between 2 dates?
My dataset aggregate value totals on a monthly basis. Each row represents an individual site and value for numerous metrics. What I am trying to do would be how to find the change between 2 months like between Oct 1 , and Nov 1, as shown above for the values in the column to the right. But I am not sure how to write the…
-
Beastmode suggestion for a filter
I have a report that provides details on individual units it has a column that lets you know if that unit is rental or unrentable. it uses binary to illustrate this: bRentable 0 = “Unrentable” or “Offline” 1 = Rentable How can I write something in the analyzer that I can use as a filter that will replace 0 with Unrentable…
-
Change the value when hovering over a bar?
Good afternoon, Is there a way to change what's being displayed as the bar values in the image below? Ideally, I'd like there to be the current hover over Percentage of Category (94%, in the example below) to display above the hovered bar instead of the 8,105,205 value. Is that possible? Thanks, Joe
-
Doing a moving average using window functions in Analyzer
I have this salesforce lead historical dataset (which tracks Lead stage changes) and I want to show a month-on-month moving average of the number of days it takes a lead to convert to the next stage (e.g. 30 days from Stage 1 to Stage 2) with Stage as series/dimension in my card. The dashboard/cards that I'm creating is…
-
Page Analyzer Links (or Deep Linking with Filters)
I am trying to create this BM calc but instead of the example shown in DOMO where you create a column with the link (Deep Link Col3) and also display the value (Owner Name Col1) I am trying to do it as one column but I am getting an error on the card. The link takes you to the page and you can see the filter is added to…
-
Problem with Flex Table input columns
I was looking into Flex tables for some of my work which includes dates, numbers and label columns. I don't why my Flex tables has only two input columns while I found on the documentation on Flex tables has three columns. Is there some configuration or anything I am missing on my organisation domo. Any help would really…
-
Calculation for days between 2 dates
I have a dataset that has 2 dates auction date and last payment date, both are in the same format "2021-06-03 05:00:00 AM" I am trying to write a beast mode that will count the number of days between the last payment date and the auction date. I struggle with any date statements, any help would be great!
-
Avg Per Hour
I'm trying to use the analyzer tool to get the average number of posts per hour. avg(COUNT(DISTINCT `Permalink URL`) over(partition by HOUR(`Created Time`))) I want to be able to use the following graph where the series is the average. For some reason, when I run the query, nothing comes up on the graph and it turns blank…
-
Comparative Gage - What's wrong with my query?
Using the Comparative Gauge, I wanted to display our performance by whether the number of impressions have increased or decreased. Only, when I use the following window functions, I get a blank card with a downward arrow. Current Month: sum(case when MONTH(`Created Time`) = MONTH(CURRENT_DATE()) then…
-
Finding the Max Average
Can someone help me build a beastmode to locate the max average? I am trying to return the average day with that, on average, shares the highest value of the week. By taking the max average of days, with the max average of days with the highest values, is it possible to discover the day that returns the highest avg? I…
-
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…
-
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…