-
Onedrive files failing
Hello, we noticed a couple of weeks ago that a bunch of sharepoint/onedrive files that we have set up to ingest into Domo on a regular cadence, are failing. The error message in Domo is the same for all of them: "Domo is ready, but the requested file does not exist" We haven't moved the location of any of these files, so…
-
Previous Week Amounts
Hello, the ultimate goal of my beastmode is to write a beastmode that will provide the variance week over week for total Net Cost. If you look at the attached picture, all I need is a beastmode that would produce the yellow column — the total Net Cost for the previous week. From there it'll be easy to then make a beastmode…
-
How to add Date Control for Apps?
You know how every dashboard comes with an automatic Date control in the top-right corner? I'm looking for a way to add that to an App where I have a few cards all using the same Date field. I need the exact same functionality where you can select a range, select how the date is broken down (by Week, by Month, etc). Thank…
-
Beastmode to display Unique Values of a Dimension
In a mega-table in Domo I have a table like in the attached picture, and I want to add another value After "Inquiries", "Core Leads" and "MVA Inquiries". That value is a Dimension called "Creative Name". All of the Creative Names within a given week will be the same. So I'd just like the table to display that unique value,…
-
Total + Average columns on a table
Hello, I'm trying to have both a TOTAL column and an AVERAGE column on a table. I haven't seen this done on any card within our company so wondering if it's possible. I'll attach a screenshot of an excel table that shows what I'm trying to accomplish. Columns must be Dates until the final 2 cols… where 1 col will show the…
-
Default date in Domo is Sunday, I need it to be Monday
Is there a way to change this? The reason it matters is if I am building a pivot table, and my date field is in "Columns", and I select Graph By = Week, it uses Domo's default week start date, which is a Sunday. So my columns will have week start dates that are Sundays. Problem is our company calendar runs off week start…
-
Mega Table - Average column
Creating a mega table card and my first field is a Date type, an the remaining KPIs are all measures. I have the card transposed so it appears as the screenshot shows (columns are dates, rows are various KPIs). My question is: is there a way to add a column at the far right that is an average of all the weeks displayed. So…
-
Color Rules on Domo Table
Hi, wondering if I can add a color rule on a Domo pivot table card. The idea is to be able to visually see how a certain row/KPI is performing by seeing the colors (see screenshot for example). I need a table format though, so it would have to be in a pivot table or mega table I think. Please let me know if this is…
-
Dashboard shows data for some, but not others
Certain users who have been shared on a new dashboard are seeing "no data in filtered range" for a bunch of cards on the dash. For other people, the data shows as normal. There is a default filter view I've set the dashboard to, but I made sure that filter view is shared with everyone. Any idea why certain users can't see…
-
Filter field timing out
Hi, have a basic card built and one of the fields I have as a filter. When I click on the Field in the Filters section, the values never load. It just loads and loads, and eventually times out. I have re-built this card from scratch a few times, and sometimes it works but eventually I get back to this same issue of the…
-
12 week average for a designated column
Hello, I'm trying to write a Beastmode that calculates the 12 week average. The column I want to average is "Net Cost" and the date column is "Week Start Date". The end goal is to have a beastmode that I can use as a value on a table that shows each distinct "Week Start Date" and the 12-wk-avg of Net Cost preceding that…
-
Date filtering removes "Compare to" lines
Hello, I have a bar/line chart that shows current year's spend in the bars, and then the two lines show where that spend was a month ago, and a year ago. As you can see in the screenshot I have the Date selected as "This Year, by Month", and the chart works great. The problem is when users want to view a different date…
-
Window function beastmode error-ing
I had a beastmode that worked (attached below), but now it doesn't work. The beastmode is intended to calculate a 12 week average for a KPI we track in the business. On the card where I'm using the beastmode, the card does not load and I get this error: "An issue has occurred during processing. We are unable to complete…
-
Default date filter on dashboard not affecting cards
I've checked and interaction is enabled for all cards on the dashboard. Across all the cards on the dash, I'm only using one specific Date field. Also I checked Edit > Filter Options and "Allow Global Date Filters" is selected. Does anyone know how to get this default date filter to affect the cards? For example, when I go…
