-
Is it possible to change the default chart type in Analyzer?
I almost never use the default bar chart in any case. So it's fairly annoying to open Analyzer, have to change the chart type and remove the randomly selected default columns. Especially if there is a large amount of data to be rendered. If it's not a option currently I think some settings should be added to allow for…
-
Change Default Chart Type and other default settings in Analyzer
I suggest an option be added to change the default chart type and column values for Analyzer. I almost never use the default bar chart in any case. So it's fairly annoying to open Analyzer, have to change the chart type and remove the randomly selected default columns. Especially if there is a large amount of data to be…
-
Beast Mode
How do i do a beast mode formula to get the response value of a record that was completed most recently? If this is my data i want to just take the bottom row. My groupings cant be changed in magic etl just need to take response value with highest or most recent time Name Location Time Response value Ben A 2:07PM 5 John A…
-
How to copy the cumulative number from previous day or 2day before or 3day before if no data.
I'd like to calculate the cumulative number from daily count and copy the cumulative number from previous day or 2day before or 3day before if no data. If there are no function on Magic ETL, it is OK to create SQL.
-
App Studio - Phone version won't turn to landscape view
I have created a handful of apps in App Studio that we are contemplating rolling out to our field teams (who primarily use DOMO on their cell phones). As I have been testing the apps I have been checking how they look on my cell phone (Google Pixel, Android phone for reference), and my phone will not show any content from…
-
Can I use the result of an aggregate beast mode as a filter for a dashboard/app page?
I have a beast mode that is comparing actual performance to a target (by categories) by taking the sum of actuals - sum of targets over an arbitrary date range, defined by user input into variables on the dashboard page. This works great as a quick filter control for an individual card, but when I make a filter card using…
-
Do new values get swept into an "all" card filter?
I can't find that this has been answered before. If I add a filter to a card and select "all," what happens if a new value is added to that field? For example, say my field is "color" and I initally only have red, orange, and yellow. I set the filter to select "all." Later on a row that has color = blue is added to my data…
-
Looking for steps to creating a historical dataset and setting up partitioning
About a year ago I set up partitioning. Since that time the platform we were importing data has sunsetted. I am now building a new dataset for Adobe Analytics. Adobe doesn't seem to like long timeframes for imports so I've imported all of the data dating back to the beginning of the year by importing month by month and…
-
Adding checkboxes to a table
I am wanting to add checkboxes to each line in a table so that I can select the check box to signify that line has been completed as I am working through the list, is this possible? Next part to the question would be is there a way to make sure the boxes that get checked stay checked after I go back to the home dashboard…
-
July Community Highlights 🌟
Hello Domo Community! It's time to recap the Community Forums most engaged posts and users in July. Follow the discussion, ideas, and user links to contribute to June's hot content 🔥 Leaderboard Top 3 We love seeing the monthly competition. Huge thank you to @ArborRose, @GrantSmith, @ColemenWilson! @ArborRose 772 points…
-
Filter Options
Is there a way to make a filter like this on a dashboard? I can do it in the quick filters of a card and then the user is able to choose in betwee, greater than, equal to, etc. Trying to figure out if I can do the same thing but on the dashbaord level.
-
Can my output include projects that don't have a column value for a Split / Group
Hi all, I have this ETL which takes a multi selection attribute (Div) with 19 values and does the following: Splits each selection option into its own column Converts the columns to rows Filters to remove instances where there was no delimiter, because if only 1 of the 19 values was selected - these showed up as "Not…
-
Sharing custom themes in App Studio
Hey all! I want to share a custom theme I've built with our company's branding for all to use in App Studio, but I don't see the option to do that. Am I missing something or is this feature not available?
-
Trying to convert list of Objects to List of numbers
I'm trying to set up a workflow that would automatically add ownership to an Admin group when a new page is created. I figured I'd first identify any pages without the Admin group as an owner. To do this, I used the queryWithSql package to extract from the Pages Governance dataset all PageIds without the admin group as an…
-
Help with Gantt Chart timeline displayed
I'd like this Gantt chart to show the full range of dates of projects that I feel like I've already defined via the Start date and End date. I don't seem to understand the options in Date range, nor why I even need them. If my earliest Project Start Date is Jan 1st 2021 and my latest Project End Date is Dec 31st 2027, can…
-
Issue with Month to Date (MTD) Calculation on the Last Day of the Month
Hey Community, I have a head-scratcher. We are experiencing an issue with our Month to Date (MTD) calculation in our Daily Snapshot reports. Throughout the month, the MTD calculation works as expected, showing the cumulative revenue for the current month. However, on the last day of the month, the calculation does not roll…
-
Change ETL Trigger Dataset is Manually Updated
Hi Domo, It would be very helpful if we could have ETLs trigger differently based on if the component datasets were updated manually or automatically. Example: If a dataset is automatically updated, then the subsequent ETL triggers should work just fine. However, if one dataset needs to be manually updated, it will not…
-
Pivoting into multiple columns
My dataset has a Month column. I want to pivot the data so that the months become the columns (so a column for June 2024, a column for July 2024, etc). Using the Magic ETL pivot tile it seems I'd have to perform the pivot for each month separately. Before I go down that route, does anyone know an easier way to do this?…
-
How to do a distinct count of a certain number of digits?
I have a column labelled "Key". I am wanting to do a group count of these as otherwise I have too many rows (in table format). The first four numbers represent a project, I am currently doing a COUNT of these, and it comes back as 1 for each as the number is unique due to the numbers after the -. Is there a way to do a…
-
Filtered Period Comparison reflect in tables
Hi I want to create a table where user can select the date comparisons between two periods. Just want them to pick the date comparison and the data reflect in the tables accordingly. And how to create another dimension with %chg based on two periods. For ex. User wants to see total GMV between Sept 1st to Sept 5th for 2024…
-
How to Aggregate Daily Data into Weekly Totals in Domo?
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…
-
SAML SSO Certificate Revocation Issue
Who Does This Apply To?: Customers using SAML SSO configured with auth request signing using the certificate with expiration date of 09/2024. (Customers using OIDC and customers using SAML without the requirement to sign auth requests are NOT affected). Summary: Due to an issue with Domo’s certificate provider, customers…
-
Load and Impact on App - Chart count
Hello, I understand we could create dashboards with any number of charts. However, I would like to understand if there is any ideal count of charts to have in a single dashboard in an App? Also, is there any recommended maximum limit of dashboards in a single App (AppStudio)? Will the limits vary from the type of data…
-
How to handle failure rates (DPPM) when Event is in different month from Sales
I need to calculate failure rates using two different date columns but the Fixed by calculation doesn't work for this. All calculations go by the date field selected on the chart, but I need a Beast Mode that ignores the default date on the chart. For instance, if I want to show units sold by Sales Date but also show units…
-
Dynamic Organization (Span) View
I am trying to find a way by which when a user view the Dashboard, then based on his/her PDP, s/he must see his/her own score and must see his/her Direct Reports entire span/ org score. I have attached a dummy data creating the scenario and along with it I have added Org Chart and the Views that is expected. Any help in…
-
Reset password
As an admin I have to reset one the user's password. I did not see the reset password button where are I found a password change button. Should I use this button only to reset user's password?
-
UI for Dataset ID
Is there any place where I can get the dataset ID information other than the url of the dataset?
-
How to Aggregate Daily Data into Weekly Totals in Domo?
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…
-
Sort or Re-Sort Available Values in Variable List
Variables continue to be a game changer for our company. One particular use case we have implemented is to create a variable with a list of all item attributes. As the list has grown the available attributes are no longer sorted in a logical way (for example, alphabetical A-Z). I think everyone could benefit from the…
-
Magic ETL Join Tile
Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper. If I join the datasets, I get different results based whether the words in…