-
Formula to just take number from column
I have a column with different assets Tank 1 Engine 1 Engine 2 Tank 2 Tank 3 Engine 4 My question is I just want to take out the number from each and put in new column so can sort by just the number in each asset. Can someone help with this?
-
Schedule a report
We had a dashboard that was scheduled to run daily and now expired. I believe that there is no flexibility to move out end date. So I saved it as a new version, but I still cannot schedule the dashboard as a whole page. I can create an schedule for individual cards within it but I don't want 5 emails coming each day. Is…
-
Lock all cards at once on dashboard
Hi, As I have around 40+ cards on my dashboard, its frustrating to go into each card and lock it individually to avoid users from editing. Is there any way this can be done at one place for the whole dashboard? I think this should stop the user from going to the Analyzer.
-
Waterfall Chart
does waterfall chart have the ability to use as filter interaction on a dashboard? I looked at Edit Dashboard/Edit Content/Change Interaction, Standard Interaction type was chosen, and filter interaction on all cards was unable. But when I clicked on certain part of the waterfall chart, other cards are not filtered. is…
-
Appending new data to an existing dataset
Hi all, hoping for some basic help and advice here. I manage a Domo dashboard, powered by a single dataset which is updated each month. Each month I am adding approximately 4,000 lines of data over 41 columns. What I am trying to achieve is the ability to add data, clean it via Magic ETL and save to the same original…
-
Is it possible to show the parcel percentage instead of parcel quantity on DOMO map?
Currently it is showing the parcel quantity by province. I want the parcel percentage each province takes to be shown on the map. How to design it? Do I have to use ETL to create a new aggregated column in % for the raw data? I do not prefer to change the original dataset because I've created too many beast mode calculated…
-
Feature to Allow for "Private" profiles
While I was navigating our Domo External Instance, Profiles / PII of Users were visible to me as I clicked through the Message, Email and Phone icons even as a "Participant". Navigating to the left or right took me to different Users. To ensure compliance at its best, it will be great if a feature to Control(Hide/Display)…
-
Multiple Filters
What is the best way to have multiple filters in the "does not contain" field. Some research lead to me that commas won't work. That the best way is to use a beast mode. Any updates on that end to filter? Example: Does not contain: S, or T
-
Total of All States on State Map
Is there a way to display the percent of a total of one state against the total of all states. Example: CA had 20 files but there were 100 across the country. I want to display 20% over the state of CA on the data label. Or will it only provide by state information? Thanks!
-
A preset Filter that has current Month
Hi, I am creating an App in App Studio and I am trying to allow the user to filter on the past 12 months. However, I want the preset filter to be the current month so that if they want to see previous months they'll have to filter for it. I tried using DOMOS date field option but when I select Current month then try to use…
-
Removing Datasets
I have been in the process for the past 6ish months of revamping the underlying data structure that feeds into Domo. As part of this I have created new dataflows and datasets in Domo. I still have a handful of reports that are populated from the old dataflow. This dataflow is turned off and the dataset is stale, but we…
-
NetSuite Created Date
Any NetSuite users running into an issue with the tranDate that is being pulled into DOMO not matching the tranDate that is in NetSuite? I attached an example of what I am talking about.
-
Magic ETL - how to structure Multiple fields that represent monlthy budget amounts
Hi i have a question concerning structuring variable fields using group by. So currently I have 12 variable fields, where a user can input a budget amount in each field, for a total of 12 months. the budgeting can start during any given month, so i have a starting month field, that the user must use to enter the budget for…
-
NULL value Handling
I'm a bit frustrated by this one. I have done everything along the path to ensure NULL values are being handled appropriately in my data. Starting from flat files and ending in a dataset (with several non-Domo steps in the middle). All of my data appears as expected in the dataset, but as soon as I add the column to a card…
-
Sum with multiple conditions
New to Domo and having trouble setting up a calculated field. I have a column "Quantity" I need to sum up if column "product code number" value is 83 and column "units" value is SF.
-
How can I combine multiple data points from the same data column into one new data point.
Hello all, and thank you for any advice. I am trying to build out a card that combines multiple different values into one on a card. For example; say a column is tracking colors. I have values of red, blue, green, white, black, yellow. Could I create a card that shows black as one value, then combine all of the other…
-
Last X Periods to Date
I would like to add to the date filters on the to right corner of charts the following options: Life to Date Last [X] [Period] to Date I have a dataset where a number exists for 'Max Business Date' each day. As the days pass, the number gets bigger until it reaches the total number of business days at the end of the month.…
-
DDX Brick
Hi Team, I am using the below code to get the first name of the user on the dashboard card by using DDX Brick App JavaScript. I want to automatically update the Dashboard Name automatically so trying to figure it out the way to achieve this. const firstName = domo.env.userName.split('+')[0]; const welcome =…
-
Table Row to PDF
I have a table on a card that contains a list of disputes. A dispute manager wants the capability to have a button at the end of each row that would allow them to print that row's content in a formatted PDF. Is this possible? Has anyone done this before?
-
OKTA CONNECTOR reg.
Why only 7 days of data is stored in "SYSTEM LOGS" of Okta connector? Can't we make it 30 days?
-
Need help with CASE statement in beast mode.
I'm getting this error on a pivot table card. The grand totals are correct but I need to see them by data source (Row) Here's the beast mode I'm using: CASE WHEN `Product` != 'SEM' THEN SUM(IFNULL(`Impressions`, 0) / 1000 * IFNULL(`Monday.CPM`, 0)) ELSE SUM(IFNULL(`Cost`, 0) + IFNULL(`Cost` * `SEM Fee`, 0)) END I've also…
-
How can I create a Beast Mode field which is a variable figure?
Is it possible to create a Beast Mode field which is a variable figure changing month by month without using SQL data transformation? because I am not very good at SQL manipulation, still in learning but need time. the field is ' top 5 provinces total parcel quantity % ' , which is the SUM (of top 5 provinces for the…
-
Percentage change in bar chart?
We have various charts comparing the current month to the same month in the prior year and it would be nice to have a percentage over the chart indicating what the difference is between the two periods. I have searched several forums and played around in ETL and beast mode, but something that seems straightforward does not…
-
Email connector
Hi, we are getting data in excel format from a service provider by email. I was trying to use the email connector, but only the data on the first page is uploaded in domo while we need the second to the 4th page. Is there another way to automate this task in Domo? Thanks
-
Dataset/Dataflow update trigger expirations
It would be very helpful, especially as customers move to consumption, to have advanced dataset update controls to have triggers expire. As an example, I have survey data that I want to update frequently during the survey window, but then stop once the survey has ended and no new data will be added. Right now my option is…
-
Edge of filters getting clipped in Domo
This is a very minor inconvenience I face when trying to build a dashboard. The right borders of any filters I add to dashboards as cards seem to get clipped. Anyone else face this issue and know how to avoid it? The right edge next to the dropdown arrow in the filter is what I'm referring to
-
Dynamic "Last Business Day" filter
Hello Domo product team, Submitting the following: would be great to see the option of dynamically filtering cards by last business day. For reference, this feature should be included in the top right corner inside Analyzer. Thank you for your consideration!
-
multiple Groups shown in just one column
Hello DOMO - Good Day! I am using the Data governance dataset that has the users and groups. what we wanted to show is the pages/dashboard and then all the groups that can view it. currently, I can show the different pages and the different groups in different columns. just wanted to know if we can show all the different…
-
Variable names in String
Hi, The current variable selector accepts the values either in Default (Numeric) - Gives a comma separator automatically. Percentage Currency - Adds $ as prefix. Do we have any work around to avoid comma? Do we have any work around to use other currency symbols as prefix with currency format?
-
Calling all Windowed Beast Mode and FIXED Function experts!
I think I'm close on this but am struggling to get my expected result. Here is my end goal—a chart showing data by date, with a line for the "Best Ever" value. Things making it tricky: I need the date range to be dynamic, i.e. user can select different dates I need the "best ever" value to be pulled from across the entire…