-
Beast mode that would put people in a specific group based upon a date
I have a dataset that shows tenants that are late on their payments. Some our in Auction status, and it has an auction date. What I am trying to do is put these people that are in Auction status in to 3 groups. Those that are 30, 60 , and 90 days past that auction date. Then Ideally, would be to use this in a pivot table…
-
HTML code is not working in table view
Hi Folks, I am pretty new in DOMO and need your help. I tried with the following code in DOMO beast mode. CASE WHEN DATEDIFF(CURRENT_DATE(), `Last updated Date`) > 3 then concat('<div style="color:red">',`Last updated Date`, '</div>') ELSE concat('<div style="color:green">', `Last updated Date`, '</div>') END but, it…
-
Slicer Select All Feature
I have a slicer card set up on a dashboard. I can do multi-select but I'd like to be able to select all of them then unselect one or a few. Is there a way to set up a select all feature so that when its embedded onto a website, users can select all on the slicer and then deselect one or more. Right now they have to…
-
Take sum of seconds and display as #hrs, #minutes
I have totaled the number of seconds for several cards and need to take the sum and show it as #Hours, #minutes. I'm struggling to find a way to do this in beast mode. This is not converting a time value but altering the sum. For example, if I have a total of 8,274 seconds First, you find the number of whole hours 8,274…
-
60 days since last pmt beastmode
I have a payment column called LastPmtDate, it exactly what it sounds like. What I am wanting to do is write a beastmode to be used as a filter to filter on only those that our 60 days or greater from that payment date.
-
Simple Beast Mode Failing on Federated Dataset
I've got a federated dataset pulling a redshift table and I want to perform some simple calculations like SUM(column1) / COUNT(column2). However, this calculation is resolving to 0 consistently despite the correct value being about 0.2. If I write a beastmode for SUM(column1) I get the correct value. And if I do the same…
-
Beastmode adding multiple different values from the same column
I have a marketing channel column. That has a dozen descriptions from all of our different marketing channels. I am only trying to take the count of a few of them together i.e. Yelp, Facebook, google ads, etc... How could I write a beastmode that I can pull out only the channels that I want to add together?
-
Pivot Table Static First Column
Hi all, I am working on a pivot table that has all Sales Reps and Counts the number of call that they've made. It accomplishes this by COUNT of Phone call, COUNT of Zoom meeting, etc. (each its own column) My columns are : Date / Call Category / Count of each type of Call. Problem: When I filter by date, anyone who has no…
-
Budget Amount and Gauge Card Setup
Hi, We have 4 sales regions, each with a different budget amount. I want to replicate a report in Tableau that has dials showing how much each region has used of their budget month to date and a Total one showing them all combined. Each row of the dataset details an expense for a labeled region. The budget amounts are not…
-
Why use a tooltip when I can use a data label or hover text?
Any instances you can share where a tooltip would be more beneficial than a data label or hover text? Maybe I'm missing the forest for the trees here.
-
How can I plot values that are in the time format mm:ss on a graph
I was able to use the SEC_TO_TIME function in DOMO to get my metrics on time duration in the format hh:mm:ss. However I am only able to see this data in a Table format. When I go to plot this on a graph it doesnt work. Any help in enabling this visualization would be great as we have many call center operations related…
-
Trying to add percentages in a pivot table
Hi, Would anyone be able to help me with the following: I'd like to have my pivot also show percentages of these two columns, I managed to get it to look like the bottom part however when I add a new column in the pivot it says the processing has not worked. Not sure how to add in the percentage? Thank you!
-
How to calculate rolling 30 days of DateA occurring from DateB
Hi all, So I had an initial question that has since been answered which was how to calculate when a date occurs within the same month of another date column but has since been answered (https://dojo.domo.com/discussion/comment/56039#Comment_56039). Now, I would like to change this up to see when column DateA occurs within…
-
How to change color and text size when using domo iframe?
Hi! I have been trying to change the color (the original color in the domo card is different) as well as the text size in the card (text size is much larger in domo dashboard). However I am not sure how to do this. Here is how the card looks in domo: Here is what it looks like as iframe: Any ideas on how I can make the…
-
changing a name in ETL
I have an employee name in my raw data shown as >>> last_name, First_name middle_initial Doe, John H. or sometimes shown as >>> Doe, John Dorian H. How can I make it so it would appear as >>> John Doe or John Dorian Doe in DOMO using ETL or beastmode? Thanks
-
Is it possible to hide PDP symbol for PDF export (or remove from instance entirely)?
We have a page that users export to PDF. The datasets on the page have PDPs applied to them, purely for Domo Everywhere/Publish purposes - all internal users have access to all rows. On the page itself, I am able to hide the PDP symbol from showing up on the bottom left and blocking card information by using the filter bar…
-
Beast Mode (Card)
Hi guys! I have repeated names that I am looking to sum via beast mode but the sum function is not working. I am also looking to select certain department numbers from a department. Please help! Thank you ^_^
-
Calculated field doesn't respect parentheses in arithmetic expressions?
Hello - I'm new to Domo but observing very unusual behaviour on a calculated field. When I define the expression 10*(2-1) It evaluates to 19 (i.e. 10*2 - 1), not 10 as expected! Bizarrely my colleague on the same instance is unable to reproduce the same. As a workaround, I've been wrapping bracketed expressions in a POWER…
-
Pivot card
Hi, I would like to know about Pivot card. I prepared the table below. The four fruits of "Product" have a value in Jan, but only grapes does not have a value in February. I visualized this data on a Pivot Table card by analyzer. Is it possible to put the name in product in order as I like? If I visualize only February on…
-
Last Month and Same Month Last Year
I'm working on ETL do get the last month data and same month last year. As it will be rolling so I don't want to do the calculation calling the Month November only in the data. (like if last month is Oct then the result will be Oct 2021 & Oct 20202 and if the last month is Nov then Nov 2021 & Nov 2020 and so on) Any Ideas,…
-
I want to create a card that provides an average monthly overview
So, we have a dataset which runs once per day and captures user log in data. It captures the latest log in count number for each user for the last week, 30 days and all time, so that we can keep track of how frequently the system is being used. I could then, for example, on the card see that on X date, we had 54% of users…
-
Drill Path from same Dataset returns zero value
Hello Dojo! Basically, I have a page that shows the most viewed pages, what we want to see in the drill path is when we drill down, the most viewed cards on those most viewed page. when I do it from separate cards, I can show them fine, one card has the most viewed page the other the most viewed card. they are using the…
-
Rolling 3 Mo Avg - Breaks Card
I want to calculate rolling average of the previous 3 months. I was going to do this using windowed lag functions ( (LAG(SUM(`Sales Amount`),1) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),2) OVER (ORDER BY `YEARMONTH`)) + (LAG(SUM(`Sales Amount`),3) OVER (ORDER BY `YEARMONTH`)) )/ 3 Each Lag works individually…
-
How do we track if a date occurred within another date column?
Hi, We have two date columns within our dataset and we want to see how many of one date column occurs within the other date column. Date Column A: Desired date to graph by Date Column B: Desired qualifier within Date Column A For example, how many instances of Date Column B within the month of September 2021 occurred…
-
Running Total Group Bar - keep running total but in a specific range of time
Hi all, I have this case that is similar to the #52547 discussion and I quote. The difference here is that I need to be able to select any portion of time that the user needs, for example, a specific year (graph by month or quarter or... ) Also, it may be able to filter by other columns. See the image attached. If I select…
-
Possible To Update All Cards On A Dash At Once?
Hi - seeking recommendations on a faster/better way to update datasets and dimensions for all cards on a dashboard. Currently clicking through each card (80+ on one dash) to update to a new dataset, and also to remove a filter. Going to add a dash-level filter once all the card-level filters are removed, but wondering if…
-
Value Average returning incorrect average when filtering?
Hi, So I am having a really weird issue with domo. I have a data set with 2662 rows and am trying to average let's say a column called marks for these students. I have created a column called percentile ranking which I created using ETL where I can see how high or low the mark is in that data set. When I create a single…
-
Nested Beast mode
Hi everyone, I have some data like companyid, journeytype, ratingid and npsRating. With ratingid and npsRating, I usually calculate NPS (net promoting score) in beast mode like this: (((Count(DISTINCT (CASE WHEN ((`npsrating` >= 9) AND (`npsrating` < 11)) THEN `ratingid` END )) - Count(DISTINCT (CASE WHEN (`npsrating` <=…
-
Pacing Card?
I wish I had access to my old domo! I built this there but cannot recall how to do it now. I attended Dreamforce a few years ago and while there someone built a bar chart that showed how you were "pacing" compared to the same time last month For example, last month we had 1000 phone calls for the month. By the Oct 17th we…
-
Graph Bar split by Quarter and by month
Hello, I am trying to split a table by Quarter and then show each month on that quarter, I was able to recreate it on Excel by using a pivot to split into quarter. If someone has come across this issue in the past I will appreciate some guidance. Chart that I want to replicate if possible I would also like to be nested to…