-
Issue Joining Datasets using Magic ETL Left Outer Join
Hello, I am trying to join two datasets one is a huge datasets that has all employee numbers in the company and the other one is another dataset that has a list of different case numbers and a requester employee number that I am trying to validate the employee number and the their tiers using the bigger employee dataset by…
-
Y axis categories not interacting on dashboard
I am working on a dashboard, and I have been able to easily link my x axis categories like date quarter or region to where if I hover over one it highlights it on all the other cards in the dashboard. If I select one in a check box it filters out on all the cards. But the same is not true for the y axis. If I hover over…
-
Domo BeastMode Que
I basically want, if an employee's attendance is marked PR PH PO PN HL HLWP HCL HEL consecutive 7 days then it should be highlighted as 1, if it is marked on the 8th day again then it should show 2 if it is marked again on the 9th day then it should give 3 and so on. I have data like Date Emp ID Attendance Status…
-
What is the string pattern to be provided in TO_NUMBER function in Adrenaline Dataflow
I want to convert a char value to number using TO_NUMBER function in Adrenaline Dataflow. The KB is given as below. What is the string pattern to be provided in the function to avoid decimals ? TO_NUMBER(STRING, STRING pattern) Converts a string into a number. An optional pattern can be passed in. If the pattern doesn't…
-
does DOMO card have this kind of function to highlight the margin concern？
On the top of the card, a control button for me to adjust the margin I concern about. I can very easily pull right or left to adjust the margin, accordingly the table can get the figures which is below the margin highlighted for me to easily focus my attention to. does DOMO card have this kind of function to highlight the…
-
Multi value gauge - WoW updating with filter
Is there a way to update the multi-value gauge with the WoW values depending on the week selected in the filter ?
-
Identify Column vs Row PDP policies
PDP icons appear on cards, but they don't indicate if row level or column level PDP has been applied. If the help text could be updated to display which has been applied that would be helpful for end users.
-
Tables imported in DOMO loosing columns
We have data into our Azure Data Lake then we ingest everything into our Domo cloud data warehouse platform as tables, but recently we noted that some tables are starting to loose some columns(like a table that had 19 columns some months ago now has 13 columns only), can someone suggest possible reason?
-
Left Join reducing Rows
I have two data sets that I'm joining on a left join. My left table is the gljedetail 2023, from what I understand a left join should keep all the rows in the left table. It reduces the number of rows not sure why it is doing it. Also, I'm using two columns for the key
-
Export to Excel: include images in cells
Current Powerpoint/PDF export is designed to be just a screenshot rendering of a card. Excel export gets more data but the Excel spreadsheet does not display the images as the card does. Please see the example attached. It would be great to have export display as is on the card.
-
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…