-
Is there any easier way to adjust date error caused by timezone?
for example, my google sheet raw data is 3/31/2024 23:16 when I upload it into DOMO, it appears as 4/1/2024 7:16 PM I had to use Convert_TZ to adjust it. this time I find there is the problem of summer time and winter time, which makes it more difficult to adjust time zone. anybody who knows more easier way to adjust my…
-
Tagging Customers on Services
Hi Community, excited to see what you think up! BLUF: How can I analyze what nurse saw a patient prior to a surgery or a non-surgery? See my simplified dataset below. My hope is to be able to see which nurses saw which patients/customers that led to a surgery (or not). My current thought is a CASE WHEN to create a label…
-
STR_TO_DATE throwing Parsing error in ETL
I am facing a error while converting string to date. This process is done in the ETL Date column has value - Jun 11, 2024 @ 14:33:22.000 Formula - STR_TO_DATE(@timestamp, '%M %e, %Y @ %H:%i:%S.000') The error showing is as attached below Note : We receive data using email connector. Please let me know where it is going…
-
Domo AI - What is available
I mentioned in today's community event that I would share some of the information we share back with people e-mailing the ai@domo.com email account. Has a good overview of what is available and key docs: If you are interested in participating in the betas for AI Chat or AI Universal Models, please work with your CSM to get…
-
Post user with custom field issue
I have created a custom field, and I want to assign a value to this custom field while creating a user. How to do this through domo api? Also when assign value to this custom field in UI, I can't see it in the get User api response. Please let me know if anyone has an answer. Below is the curl request for reference. Kindly…
-
Blank Brick
When I create a blank brick in Domo, it builds out a card with area for javascript, html, and css code. It also adds three datasets to the domain. I replace dataset[0] with my own dataset and get the card working. Terrific so far. But I never needed that example set in the first place. Now I want to delete those example…
-
Is it possible to have multiple bars(metrics) on y-axis?
I have date field, and a Type (Pen, Pencil, etc.,) and I have actual Revenue and Forecast revenue. I want to know if there is a way to compare side by side for the revenue and Forecast using the stacked bar. I could achieve using the trellis categories but the viz is not what I anticipate for the comparison of Revenue vs…
-
Fixed Function At Two Levels (Or nested Fixed Function)
I have a data set that includes duplicate rows for products. I'm using a fixed function to de-dupe an aggregate sum of product prices because I only want one product row to contribute to the total. The fixed function (total_product_price) looks like this: SUM(DISTINCT Price) FIXED (BY Product ID) However, now I need to…
-
Has anyone successfully used a connector to subscribe to an MQTT Broker
I have found the following article, which describes my requirements exactly, but can find no such connector. Am I missing somthing?
-
Help with column formula
I am trying to do an a calculation and having some trouble. The formula in my Average Daily Usage column is (Oil Usage / Run TIme Hours) * 24 I guess the formula is technically working when look at columns, but I want this formula to calculate for the subtotal columns when i select a range of dates. So the column in blue…
-
Admin > Content > Dashboard Links
Hey team! Simple thought, but would be a nice to have functionality. When in the Admin > Content > Dashboards (or pages) it would be great if the title of the dashboard could be clicked on or the details would have a link option so that we can access that dashboard from that place. Use case - often time we may be…
-
Domo Changing Values
Anyone know how to make sure domo doesnt change values in my uploaded excel file? Clearly, everyone one of the values in the excel file has .XX and nothing more. Domo is adding values to the upload. How do I get this to stop?
-
Not able to append the dataset in Workflow
I was able to pass the value, my workflow is showing status as completed. But not able to see the new records in the dataset. I have created my own code engine. Below mentioned is the link. Using version. 1.0.2. https://bareinternational.domo.com/codeengine/761fcf57-8592-45c6-9f37-1adf5b795473
-
Workaround to Pivot tables pushing non-valued categories to the bottom.
Hi, I'm currently trying to build out a pivot table with custom sorts on both the row and column values. As has been mentioned before on the dojo; pivot tables will always override the sort so that non-values will display last even with a custom sort including the column/row headers. Has anyone found a workaround to this…
-
Anyone using Google Admin Connector
I have tried to set up the Google Admin connector but after authenticating I just get the messgae "This app is blockedThis app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access." What do I need to do within Google in order to allow this?
-
Change tracking in version history
Through the `versions` tab when viewing a dataflow, allow a click in that displays a graph of the ETL with highlights on all tiles changed from the prior version.
-
Dynamic Segments
Good Afternoon, I am needing assistance with making a segment on my line graph dynamic based on the applied filters. Currently, I have a segment that sums the total spend by paid ad sources. However, when I apply filters for different sources the total segment number remains unchanged. Ideally, I would like this segment to…
-
Can't open Course Builder
Hello, I've downloaded Course Builder App for Mac but couldn't open it. It says 'can't be opened because Apple cannot check it for malicious software. This software needs to be updated.' Anyone has any suggestion on this?
-
Customising spacing in grouped bar chart
-
App Studio Text Card Headers
Has anyone run into this issue with App Studio? On a computer, the grey pills at the top display text headers. On the mobile version, they are empty. I’ve played around with modifying size, text color, background color, spacing, margins, styles, themes. None of it seems to make a difference. Anyone have any ideas? Mobile…
-
Workbench Extremely Slow Out Of Nowhere
Hello All, One specific dataset for some reason has started to "crawl" when processing. It used to take anywhere from 5-10min to process but now it is only processing around 3k rows every 5 min. Any idea where to begin to look for a reason of this to all of a sudden happen? We have this on a 2-hour schedule so since it…
-
help in building a form and embedding
I am planning to build a form with DOMO everywhere or App studio that has few contact info fields and two agreements that need to be checked by the user before submitting it. the agreements can be embedded within the form and allows the user to accept it and are required fields. These forms need to be embedded on the…
-
DOMO Forms
Has anyone worked on DOMO Forms ? I am trying to create a form, which when filled up, will send an email to a specific person with the form that was filled out. Any suggestions?
-
Case statement not counting correctly
(SUM(CASE WHEN Age >= 31 AND Age<= 60 THEN 1 ELSE 0 END) / Total Inventory) * 100 When I break up the statement it only returns 0 and there is a handful that are in the data. I have check the filters and if I'm able to see it I don't understand why it doesn't count. Any ideas?
-
Back arrow on Drill Path
Hi, For some reason when I have a drill in place card on an app, I dont get the option to go back once I drill down(the arrow in the top left of the card once drilled down). Is this a feature that is possible in app studio. App studio card when I drill down. Dashboard card when I drill down.
-
Olo Data Connector
Has anyone connected / created datasets from Olo? I have created the account connection but the help file on the Olo connector doesn't match the panes described…
-
Appstore wants to hear from you!
We on the Appstore team actively want to hear from you! If you have ideas on the experience of publishing and "getting" things from the Domo Appstore and it's functionality as a platform marketplace, now is a great time to share that with us. We are actively monitoring this category for ideas as we continue to plan the…
-
Conditional Card Display on Dashboard
We have customers with different product offerings that can affect a card or two on a standard dashboard. Would LOVE a means to conditionally display a card. e.g. On a dashboard, if Condition A is met, display Card A. If Condition B is met, display Card B. Using the same dashboard real estate.
-
Change banner color
My company has 2 instances of Domo (Sandbox and Production). It would be super helpful to be able to change the banner color, so that users can easily and visually see which instance they are in.
-
Excel button to refresh data
Hello, I have 2 questions. what is "live data mode" in the Excel O365 add-in? Is there a way to create an Excel button which calls Domo Data Refresh all, instead of using the file menu at the top to refresh the data? Thanks for the help.