-
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…
-
Separating words in a column where certain words have more spaces than others
I have a column in a dataset of production data. The column is formatted as follows: Production Cherry Tomato 12x1pt - Packed Beefsteak 15 LB - Restack Mini Sweet Peppers 14x4 FM - Packed I'm wondering if there is a way to pull the "12x1pt" "15 LB" and "14x4 FM" into a column for "Size". Given the varying amount of white…
-
SUM(DISTINCT) or other function?
Hi gang! I've done a mockup here to try and explain what's going on with my dataset and what I want to achieve. The first table below shows my dataset. We don't need the month column for this, but I wanted to include it to explain why each project has multiple rows in the dataset. Essentially, I want to SUM the PlannedCost…
-
Is there a way to track which DOMO assets (cards, datasets, dataflow, etc) uses a specific field?
We found the Card Fields & Beast Modes Governance dataset which shows what fields are being used in cards and beast modes but we would like to track a field name from it's original dataset > name change (if it applies) > DOMO asset.
-
Governance Toolkit
Hi, I am new to the tools within the governance toolkit. I have been doing some research but wondering if anyone has any use cases for, or explanations of the following tools: Dataset Backup: Is this just a safety measure to take before you modify an existing dataset? If so, what would be the difference between this and…
-
Filters on Multiple Pie Charts
I have the following on a dashboard: I want the user to be able to filter the left and right charts using the slicer for different time periods, without resetting one when the other is used. Meaning, I want the left chart to show me FM6 and the right to show FM7. Any ides how I can go about this? The charts are already…
-
Background Image App studio
How to have different Background Image in App Studio for EACH page. I dont want all pages in App Studio having same background Image!
-
Finding Statistical Significance for A/B Testing
Hi there, I have a dashboard for reporting on the results of my A/B tests. You select what experiment you want to look at from the filters, and the KPIs are populated for each variant, as well as a Lift/Decline for different metrics which is calculated through different Beast Mode Calculated Metrics. My question is, is it…
-
Background Image in App Studio
How to change the background in App Studio for EACH page. I DONT want my page to have same background for the whole page in App Studio. Not convenient at all cannot use different background image
-
Offset DATETIME Data Based on Personal Time Zone
The documentation (https://domo-support.domo.com/minasan/s/article/360042934394?language=en_US) states that Updating your personal time zone doesn't offset any DATETIME data you are viewing in Domo to display in your personal time zone. Only the company time zone offsets any DATETIME data. I'm really puzzled by this. If…
-
Globally assigning Beast Modes back to Datasets rather than just to cards
Maybe this is WAY out of scope, but it would be helpful if there were a way to globally "reassign" card-level Beast Modes back to their source datasets, or at least to somehow trigger ONE copy of a card-level Beast Mode that is replicated across multiple cards back to the SOURCE dataset. Perhaps I don't fully understand…
-
Grouping beastmodes from different datasets in beastmode manager
Is there a way to group beastmodes from different datasets in the beastmode manager? In our instance, we have multiple datasets that serve different business purposes but have the same name and beastmode formula. If we can group them together as one in the beastmode manager, it would not only better organize the beastmode…
-
Parameters Defaulting to First Option when Published.
I'm having an issue where a specific parameter will default to choosing whatever is first in it's DROPDOWN options list when it's published. It works perfectly when in the Custom Connector Builder, but when I self-publish, the issue arises. What's causing this?
-
Domo Workbench Writeback Provider plugin has expired
Hello, I use Domo Workbench Writeback Provider Plugin to automate process to move data from domo to oracle table. Process of using Domo Workbench Writeback Provider was working properly until yesterday when I get message that Domo Workbench Writeback Plugin has expired. How do I make this Write Back provider permanent?…
-
Pivoting multiple columns with the same column values as its values
I have a scenario where I have rows from multiple columns that I want to pivot into a multiple columns. Let's say I have three columns: 'Questions,' 'Labels,' and 'Values.' I tried pivoting the 'Questions' column into separate columns with values from the 'Values' column. Now, I also want to pivot the 'Labels' column into…
-
Changing the input datasource to multiple ETLs at once
I have a table that powers multiple ETLs and I want to change this table in all the ETLs to another table without changing it individually in each ETL. Is there a way I can do this or view what ETLs are powered via Domostats ( I know I can check this in the Lineage tab) but I want it in a table so that I can analyze the…