-
Group Total - Aggregated Series
Community, Is it possible to have a drill down that retains the prior level's aggregated top-level value? I.e. I want to be able to drill down from an overview, into a series specific break out (And here's the kicker) while maintaining an additional series that displays the group total from the prior drill down. For…
-
Percentage calculation using beastmode
Hello Everyone, Please help. I am getting syntax error when I'm trying to rewrite this formula in beastmode. Below screenshot of my formula how it looks like in our database that I want to re-create using beastmode: I want to get a Loss Ratio percentage between 0 to 100. and results should have a percentage sign with 2…
-
How do you change the field used for the date range on a card?
I need to make a table with two date fields (report_date and report_sent_date). Domo used to allow you to choose a date field that you used in the Date Range, but now it longer lets me do that. If I just have report_date, that is the date field used on the card. But whenever I have both, it changes the date field to…
-
Smart Text card title show year with a comma. How do I get rid of it?
So instead of '2024 Sales', the title shows '2,024 Sales'. How do get rid of this comma? I used 'Display any filter' Sales as Card Title
-
Domo Ovation Awards are live: nominate yourself or a friend!
The Community Member of the Year award will come directly from this platform: our engaged Community members (YOU) in the Forum. Many of you are amazing candidates for this award and we want you considered! If you believe you've made an impact on the community or have another Community member in mind for this award, please…
-
Programs Ending in the Next 60 Days
Hello Everyone, I'm trying to create a card that will show what programs we're running will end in the next 60 days. I think a beast mode would help accomplish my goal but I'm unsure of what to do. Each program has multiple billing dates associated with it so I need it to be based off of just the latest billing date.
-
Convert to timestamp
Hi, I have a process_timestamp column with string values like this: 2024-09-17T14:47:41. I am trying to convert it from a string to a timestamp in the format 2024-09-17 14:47:41. I used the formulas below in my ETL, but they are not working, and I get this error message "failed to convert value from type string to type…
-
Group By and Drill down
Hi, I am new user of DOMO and need help building this report: I have a data with columns: Name, Age, Birthday, Position, Email, Salary. For initial screen I want a filter channel by Name, Age and birthday. Then allow user to drill down into each Name for Position, Email, Salary details. Thank you!
-
Need to get TOP 10 only
Hi, I build this card using a bar graph and aim to get the TOP 10 PERILS only. What formula in beastmode can I add just to get results for only the top 10? Columns used: "Peril" and "Peril Counts" Thank you!
-
Dataset Views Governance
The versioning history available on Dataset Views is only accessible when editing the view and doesn't appear to be included in any Governance reports. In addition, the version history view lacks key information such as old/new calculated field syntax and user info. Finally, the version history view appears to attribute…
-
Custom Themes for DOMO Apps Beta
I'm wanting to know if/when we can create custom themes that are saved across for all app creation not just within the individual app being made. When you go to pick a theme there's a "CUSTOM THEMES" tab, but it is always empty because it is a brand new app being made. Just a suggestion because multiple users and DOMO…
-
APP PDP Policy View
I am trying to figure out if there is a way to be able to view an app from different PDP policies, I am the admin and I am trying to build out apps for people but want to be able to test and see what others are seeing based on their PDP
-
Group By/Drill down
Hi, I am new user of DOMO and need help building this card: I have a data with columns: Name, Age, Birthday, Position, Email, Salary. For initial screen I want a filter channel by Name, Age and birthday. Then allow user to drill down into each Name for Position, Email, Salary details. Thank you!
-
Previous Validated Formula now Domo is not accepting
Please help: I have a beastmode calculation setup before that creates a Date using month number but now Domo is not accepting it. Here is the formula: DATE(CASEWHEN LENGTH(`Month Number`)=1 THEN CONCAT(`Year`,'-0',`Month Number`,'-01')ELSE CONCAT(`Year`,'-',`Month Number`,'-01') END) This is the error message that I am…
-
Change drill path or legend
I have a scatter plot that has 400 individual 'units' each with a different unique name. I have the series set as a quadrant identifier of their progress that will classify them by colors. So when I add a drill path I will click on individual dot and it will drill on the quadrant identifier that shows all of the unique…
-
Mouseover popup for dashboard descriptions
It would be very helpful to users that when and admin or power-user is creating a dashboard to have to fill out a description field that would display when a user hovered over the dashboard name in the left navigation menu
-
Certification with Group Ownership
Does anyone else notice an issue when you request something to be certified and it is owned by a group? I requested a dataset be certified and I am in the group that owns it. When I go to the certification center it shows I submitted the certification but gives me an error and does not give me the option to choose which…
-
How can I control Line Chart Colors? They aren't matching theme.
See title. Line Chart Colors are not matching my theme, they are doing only shades of a color not included in the theme I have set. Am I missing something here? Thanks!
-
Various visual tweaks
Hi, I have a few questions regarding dashboard/cards visualizations. Here is the exported version of of my dashboard: The 2 filled gauge cards (upper middle and upper right) are the same exact sizes in my dashboard. Why does the middle gauge appear slightly larger when exported? Is there a way to fix the size to make them…
-
Card/Dashboard Details for Apps (Last Updated, etc)
Cards and dashboards that are in Apps are visible in the Admin area where non-App card and dashboard details currently reside however, there is no detail related to the cards or dashboards. The only detail available is what cards are on the dashboard in Apps and not when it was updated, viewed, etc. We would like to see…
-
Organizing Global Filters in Apps
We would like the ability to organize global filters in Apps. We create global filters for our most used filters for clients but we aren't able to organize the filters in a logical way. The filters appear in the order of selection when setting up the global filter, but it would be helpful if they were alphabetized or you…
-
Ability to disable access to specific instances for Office 365 Add-ins.
I would like the ability to disable access to specific instances for the Office 365 Add-ins. We have multiple subscriber instances and have users that have access to all of them. However, we only want them exporting content from the main instance and not any of the subscriber instances. Currently, there is not a way (even…
-
Tips for Setting up UKG Connector
Here are some tips to succesfully connect data from UKG UKG vs. Domo Conector User API Key = User Access Key Customer API Key = Client Access Key Services Host Name: Needs to have https:// in front of it but here is some documentation from UKG that will help you get that. https://{{HOSTNAME}}/services/BIDataService Web…
-
PDP Help
I am trying to set up PDPs for my sales team, we have instances where we want the PDP to be based on multiple criteria. For example, I have one sales rep that I want him to be able to see all the data for rows that have him as either the primary or the secondary sales rep. Primary and secondary sales rep are both…
-
Netsuite Analytics Connect
Looking for guidance on what other users are doing with Netsuite Analytics Connect. For example, I have a table of transactionline and transactionaccountingline. Each of these tables is 9mm rows and I need to join them together to get a master transaction table. I was hoping to do this in the native connector but it looks…
-
Why is the Searchable DDX brick not filtering the page?
Hi, This is driving me nuts (someone with very minimal JS). The only code ive changed in the DDX brick is as followed. How come when I select a report number from the DDX brick, no cards get filtered and the global filter doesnt update? However, if I use the control on the right side of app studio, and select a report…
-
PDP issue on Dashboard with more than one dataset
I have a dashboard with 6 cards. 4 cards are on General Ledger Data Mart, 1 on Accounts Receivable Data Mart and 1 on SO Document Detail. All 3 datasets have identical PDP using the value of the 'Division' column. When looking at dashboards where only 1 of the above datasets are used, PDP works without issue. But when I am…
-
Export Filtered Results
{I think we already posted this request but I don't see it.} When I filter a dataset and export, the export contains all the data and all the fields. I want export to only export what is displayed. If a filter is active, the export should only contains records that match the filter. I keep having to create cards just to…
-
Beast Modes for Column Headers
I have a table card that shows data over a static 6 week period and a rolling 6 week period. Because of this the date ranges for each week would change depending on when the dataset was last updated. It would be awesome to have column headers that are based on a beast mode so that they can change dynamically.
-
App Studio - Move/Copy Card Functionality
I love that in the Admin > Cards area it now shows "Dashboards and App Pages" for card locations. A further "nice to have" enhancement would be to see the App title listed under Move/Copy when looking at a cards settings. In this example- I know this particular card is both in my overview and on our Analytics Hub app.…