-
Make Domo Make Sense
Can someone please explain this logic to me, I am so confused. I am taking some avgs right. Here is my data by day, I have a function to find the max value for the timeframe. You can't see the rest of my numbers in the screenshot but they are between 197 and 205. As you can see 211 is my max for the month. If I use the…
-
New Customers/
Hello, I'm working on visualizations that aim to show new customers within years. My database contains data from 2020 moving forward. I want to see new/unique customers that bought from us for the first team this year. If it is possibly want to compare it to 2021 too but struggle to filter that out or write a beast mode.…
-
How do I format?
Hi all, I am working to generate a report but am not sure how to calculate in Domo to get the visualization right Right now, we are looking a property type breakdown by year - included on the y-axis is the number of loans we had each year. We are trying to keep the years on the x axis but only show the property type…
-
Trying to Count the number of Appointments in my data
I feel like this should be simple but I'm struggling with how to write the beast mode to where I get a whole number and not an average. I'm trying to count the total number of appointments in my sales data. This is what I've written: Count(`Bay Text`)/(COUNT(DISTINCT`Invoice #`)) I've attached a photo showing what the data…
-
Stats for number of Cards per Page
Is it possible to get the following information on a card? List of Pages Owner of Page Created Date of Page Last data of data refresh Number of cards on the page I've tried doing this using Domostats data but can't find a dataset where I can get this information, especially the count of number of cards per page. Any…
-
Problems launching analyser
Hi, I've noticed a new version has been pushed to our instance as the share on dataset checkbox on the beast mode dialog box has moved up towards the save button. Anyway we are having problems launching the analyser for lots of cards now. You just get infinite loading and have to close and retry to get it to show up.…
-
Start day of week
Hi, We have fiscal calendars loaded onto our instances which work great but we have the scenario where we need the calendars and pivoting mechanisms to work on calendar year (default) but Monday - Sunday weeks rather than the default of Sunday - Saturday weeks. Can this be toggled for an instance? Thanks
-
Unable to sum a beast mode formula
I'm trying to get the first and last days of the selected date range and return dollar amounts on those days. When I use the following formula I am able to sum the dollars CASE WHEN `InventoryDate` = '10/1/2022' THEN `dollarsOnHand` ELSE 0 END When I use the following formula I lose the ability to sum the column CASE WHEN…
-
Sorting order of sub-bars in nested bar graph
Hello all. I'm working on a nested bar graph. On the x-axis are calendar months (represented as 2021-4, 2021-5, etc). The y-axis has a count of tasks accomplished. As the data table shows, a task can be Low, Medium, High, or Uncategorized priority, and the greyish-purple background bar for each is the sum of all tasks in…
-
Trying to get card that shows the row count that is shown in the data warehouse
I am using the Domo governance dataset to get the total row count, but the total is way higher than what is shown on our data warehouse page.
-
Alerts - SMS Character limit
Hi, Just want to ask if anyone knows or explored what is the character SMS limit in DOMO Alert? Thank you
-
Number of week calculations for fiscal YYWW (Year, Week of year)
In our DOMO instance, there are many datasets where we express the date as the Year and Week of year based on our fiscal calendar represented as a string. See attached graphic: For example, with today being October 25, 2022, our fiscal calendar says we are operating in week 2244 of this year. Year = 2022, week of year is…
-
How do I get the summation of a group of numbers to display?
The table below is a breakdown of the top table -- and it should be displaying the same information. Could anyone help me understand why this is happening? Here is one of the Beast modes I'm using for this calculation. (Top table) It seems to me that I'm only getting one rows worth of data being displayed instead of the…
-
Filtering Report Data by Multiple Dates
So, I have a dataset, Appointments. An appointment has a Created Date (the date the appointment was made by a scheduler) and a Scheduled Date (the date the customer is scheduled to come in). These dates are used for different metrics: Created Date is used for Conversion (to see how many customer interactions in a period…
-
Dynamic Dates
I hope I can explain this clearly - I need to create a subset of the date field which is fluid and changes as the dataset updates. For example: Last-16 days thru last-8 days(so if last-16 =9/16 and Last-8= 9/8, then the next update it will be 9/17 - 9/9) It's similar to BETWEEN RANGE in Analyzer, however the Between Range…
-
How do I get my subtotal and total rows in Table card to show the avg of % rather than the sum of %?
For the column of my table that's using percentages, I'm getting these percentages through a beast mode: count(`Opportunity.CreatedDate`) / (case when `Team Months Active` <= 1 then 40 when `Team Months Active` = 2 then 80 when `Team Months Active` = 3 then 120 else 160 end) For some reason, the Total and Subtotal rows of…
-
Help with filtering Null Value
Hi, I am creating a beast mode case when statement. sum(case when `lgract` = '4001' then `crdamt`end ) - sum(case when `lgract` = '4001' then `dbtamt`end ) What I need help with is sometimes crdamt returns a null value. I would like it to revert to a 0 value in this case. I believe I need to use NULLIF(crdamt, 0) However I…
-
Export All Names of Beast Mode Calculations
I need to export all names created in the beast mode calculations for a dataset. However, I don't have admin rights. I have been trying to create a table using Charts and add all of the beast mode calculations as columns manually. However, it returns the message below. How do I resolve it? Is there a faster way to achieve…
-
Can you set a max number of lines on a multi-line graph?
I am working on a dashboard that utilizes a multi-line graph. For this dashboard, you filter down to the specific products that you want to compare and then look at the line graphs where they are overlaid together. This dashboard has worked fine in practice, but if anyone goes directly to the card or accidentally resets…
-
Assistance With Creating a Bar Line Graph
Hello, I am trying to figure out how to create a line graph / bar line that will give me the variance change year over year based number of claims per year. I am not sure if there is an easy way/setting in Domo to automatically create a percent change YoY for me, or if I need a beast mode to do this. I have tried the…
-
Cards are not sharing Properly while sharing the dashboards to the user
Hi Team, I have created new role access in DOMO which was inherited from the participant role without including the "Export option" in it. It means that nobody can export anything from cards or pages. My problem is, when I am sharing the dashboards to the people who have my custom role can see the dashboards on the left…
-
Case Statement Help
Is it possible to get the summation of fields (site kits, chat, vendor, dkr, returns) while using those fields at the same time in DOMO?
-
Color Rules based on column not used in chart
I have a chart that shows actual data and forecast data on top of each other (see attached). However, I would like to be able to change the color of the curve based on the "Actual/ forecast" status of the data. For example, for each curve, part of it will be actuals (let's color it in red) and the rest will be forecasts…
-
Add a vertical line on the chart between actual and forecast dates
I have a chart with x-axis = dates and y-axis= sales. Want to add a line between actual date and forecast date to show the left part belongs to actuals and the right part belongs to the forecast. Additionally, if I can label the left space as actuals and right space as forecast that would be great. Any suggestions?
-
Creating anchor tag for cards
Hello, We are using iframe to load DOMO report in our application. We are passing DOMO url and token to iframe source. We have one application which sends email to users. EMAIL body contains one hyperlink. On click of that, we are navigating user to HTML page where iframe is added. This Domo Report have 2 cards. Now, we…
-
Why have the dates changed?
So I have put together a multi data source dashboard for our company. Yesterday, before everything ran overnight, all of the years worth of data was showing up. This morning, without changing any filters, the graphs are only showing about 15 years worth of data. My instinct said that somehow the update caused to data to go…
-
alternative for parameter in Tableau
I would like to build "interactive chart", so user can choose what will be displayed on Y axis (SHIP TO, SOLD TO, customer group- see attached image). In Tableau I used Parameter for it - but as far as I read this option does not exist in DOMO. does anyone knows any alternative solution? thank you!
-
Card updates later in the month than other cards - Beast Mode to keep previous value until update?
Good morning, I have a dashboard with cards set to update once the month turns over - however several of the cards display data that update about seven days post-month change. During that seven-day period, the cards display no value. Is there a Beast Mode that would allow for the cards to continue to display the prior…
-
Can I display data in Kanban Board format or would I have better luck finding a unicorn?
More and more I am getting asked if there is a way to create a card/report where the data is displayed in a Board format (basically, vertical columns with activities slotted into the respective column). Looking for a creative, "elegant" solution....really surprised there doesn't appear to be a Card Option to create this…
-
Exporting a filtered file
Hi, I recently joined multiple data sources together and we are going through and sifting through the data flow. Almost everything looks good except 5-6 columns have nulls when we are expecting data. For example we have 109,000 thousand rows and all 109k have loan IDs in them but there are only 105k rows with purchase…