-
How Can I Hide The Subtotal Label Value?
We tend to use subtotal rows more for grouping than we do actual "sub-totaling" the rows. When no subtotal label is entered, it will just default to "Total". How can I have no label and just bring up the record value only? Also, any tips and tricks about grouping rows? Has Domo ever thought about allowing you to group…
-
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…
-
What does 'Last 3 Years' mean?
Hello, When Domo uses 'Last 3 Years' for a date range, does it mean data from 2018, 2019, 2020, and to present date in 2021, or 2019, 2020, and 2021? Or is it April 15, 2018 - Present Date? I am having some data that I expect in my results, but there is some data missing and I think it is because I am using the 'Last 3…
-
How do I preserve color in custom chart?
Since cell color options are lacking for pivot tables, I decided to use a custom chart. But when I upload my svg, all color information gets wiped. Is there a way to preserve it like the example that you have in your custom charts site for college campus map?…
-
Unify two filters in one Beast mode function ?
Hello, In a card, I edited a Beast Mode function in order to combine two filters: (case when (`Distributors`='DistributorA' and `Country`='CountryA') then 'Distributors' else 0 end) (case when (`Country`='CountryB') then 'Distributors' else 0 end) I would like to combine these two in one unique Beast Mode function like a…
-
Frequency Chart / Histogram
Hello, I have a range of Velocities (ft/s) and I am trying to show how many jobs we have performed within this range of velocities. I need to remove the decimal places and would like to round the numbers up. Is there a function to do that in beast mode or ETL? Then I would like to create a card that shows number of jobs…
-
Values showing as Number with K -how to remove/change?
Hi, I have a list of pressure values in psig and I am trying to show a histogram of the range and number of jobs we have done at these different pressure values. The issue is that the column is a number and when i create the chart, DOMO is picking up with psig value as a number and adding a K to it. How can I change this…
-
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`) =…
-
I am trying to get the timecards created this quarter for last quarter
I am trying to get the timecards created this quarter (Q2) but for last quarter (Q1) the reference dates are created date(current quarter) and end date(previous quarter) so, I have this created in beastmode>>> (case When `TC: Created Date` >= '4/1/2021' and `TC: End Date`< '3/31/2021' then 1 else 0 end) how can I make the…
-
Changing Date Format in Period over Period Additional Text
Hi, I have a Period over Period Multivalue chart. I am comparing yesterday's number vs same day a week ago. When I add the CURRENT_PERIOD_DATE AND PREVIOUS_PERIOD_DATE in the "Additional Text" they show up like below (2021-04-11 and 2021-04-04). Is there any way to change the format? I want it to show up as 04-11 vs 04-04.…
-
Global Map, can you have dynamic filters
Hi, I have a global map card which shows our total number of jobs per country. We have different job types and ideally I would like to show these on the map but in a different colour. Is it possible to have the map coloured in relation to the filter "Job Type"? Thanks,
-
set custom start days of the week at a card-level
Hi All, I want to set custom start days of the week at a card-level, I referred the article(https://dojo.domo.com/discussion/47172/changing-a-day-week-start-to-friday) and created below beast mode. case when DAYOFWEEK(`Start Time (UTC)`) = 1 then 6 -- Sunday when DAYOFWEEK(`Start Time (UTC)`) = 2 then 7 -- Monday when…
-
Help with Beastmode on Count with Condition
Hello, I feel like this should be a simple thing to do, but am stumped. I am trying to do a count of order numbers where there is a condition to be met. Is there a if function that I can follow to do this? For example, there is a list of vendors, some of which have registered and some have not. I want to count the # of…
-
Beast Mode Calc for URL Won't Activate Intranet Links
I have Domo connected to a data source where users provide URLs. Those URLs come into Domo as text, so I created a beast mode calc to activate is a link in Domo. The beast mode calc is as follows: The calculation works just fine for links to internet sites. Here's an example of it working when source value is populated…
-
Hide row in html table if column data is empty
Hi all, We have a business rule where we only show data if the number of rows is >=7 because of privacy/pii concerns, and we do that with a beast mode calculation, and apply it as filter CountRespondents: SUM(COUNT(DISTINCT `ratingid`)) OVER () But when I want to filter/hide the rows where the Comment is empty, the…
-
Summary number
Hello I have a card that showed target value set for the whole year, vs the target attained till current_date. This is a grouped bar, where one bar is target, and the other bar is attained target. I want to display the summary number that displays the attainment for current month. When I choose 'all values' it gives a…
-
How do I calculate a row total?
My columns also have text and numbers. I want to sum the numbers, ignore the "N/As"
-
Tracking Google Analytics for Coursebuilder
Hi all, I have followed the instructions in the knowledgebase on how to set up tracking for Coursebuilder using Google Analytics and I am seeing some data coming through - the problem I face is that I don't know what fields to bring back in order to understand Which course they have accessed What pages they have viewed…
-
Generate an Average ignoring duplicate rows
I am trying to generate an average value for a single value card, The data has duplicates of this value due to other data within the set. In the example below, I am looking for the average number of seconds per customer. I need to be able to dedupe Customer 1, then average the remaining rows. Can this be done with a Beast…
-
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…
-
Table Card - Total to be % calculation rather than SUM, rows by week
Hello, I've attached an excel workbook showing a sample bit in its raw form, what I want to get out of that, and what I am getting. I'm primarily having two issues: Getting everything on 1 row by fiscal week. I can accomplish this until I add a percentage beastmode, then the rows will no longer be condensed to 1 row per…
-
Count (Distinct) With Condition
Hello Domo Experts, I am having a hard time navigating around this one. My goal is to get a unique count of 'evaluation_id' where an error has occurred. I have created a column for when error occurred using beast mode, but when I try to count Distinct Eval Ids does not seem to give me what I want. Any help appreciated.…
-
Change line type to dashed in line graph
Can the line type be changed from a solid line to a dashed / dotted line in a line graph? There are old posts where it was determined this is not possible but I would hope this has become available now.
-
Combining outputs from 4 different cards and 4 datasets I don't want to join together
Hello, Hoping there's an easy answer to this. I have 4 different cards coming from 4 different datasets with no common fields. So I don't want to join them together. The 4 cards created are 1 number cards showing a dollar calculation (let's call it "profit"). Card #1: Profit from Sales ($100) Card #2: Profit from…
-
Moving Jupyter Notebook Graphs to Domo
Hello all, I was wanting to do some analysis on a data science model that I made where I was trying to gather inference or find out which variables in my model had the most influence in creating its predictions. In doing so, I used the SHAP package and created a visualization that I would like to transfer into a card. Is…
-
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…
-
How do I create a filter to show only the UPPERCASE records in a spreadsheet?
I am importing a CSV file. It has both UPPERCASE and lowercase entries in a single column. I would like to filter out all the records that are not UPPERCASE. The end result would be that all mixed case and lowercase entries would NOT be displayed.
-
Sum of two beast mode calculated fields
Can someone please help me with the below scenario: Where A and B are calculated fields. I have to show the sum of A and B in the card.