-
Strange datetime behavior when using the Five9 Domo Connector
I am using the Domo Five9 connector to pull a report containing list data into Domo and am encountering challenges relating to datetime fields. The two fields I am having issues with are: Timestamp - This field tracks the date and time that a given record was added to a list. created_date_string - This field within Five9…
-
Error with Domo --> Excel Add-in
I've been using the Excel add-in to pull in data from domo successfully for a while now but I'm getting this error today: — Error code: aW5zZXJ0VGFibGVFeGNlbA== TypeError: Cannot read properties of null (reading 'join') Environment: extensions.domo.com/office365/addins/ — Does anyone have a solution for this?
-
November Community Recap 🦃🍂
Hi Domo Community! Skim or follow the links below to quickly see November's top content. Feel free to like, agree, upvote, and comment on discussions you find helpful. Postitive reactions give points to the author to help them rank up. Catch up on the latest AI Livestreams Unlocking AI Potential through AI Readiness…
-
How to reduce the gap between the grouped bars in Domo card?
I am currently building a grouped bar chart by year. I find the chart inappropriate with a lot of space between grouped bars making it look visually unappealing. How do I decrease the space between the grouped bars and make it look presentable?
-
Text column as values in Pivot table.
I have a column that is based on calculation of ranges and identifies the risk category. I want to set that column as values in my pivot table , however it is not accepting the text column as values. How can I achieve this?
-
Swap Y-Axis Scale and Second Scale
In the vertical-bar-stacked-plus-line chart type I'd Like to be able to make the second scale the Y-Axis scale and visa-versa. There is a place to hide the second scale.
-
I need help with my equation
I have a multi-tiered equation based on criteria. Initially, I have many nested Case statements, but it didn't work so I tried to simplify. I need an equation based on the job open date, the customer, the proceeds A and proceeds B. So before 10/1 we had a straight fee based on a % of the proceeds A. After 10/1, we use a %…
-
Reusable "drill path"/cards
This request was previously submitted and the support team has instructed me to submit it again: A common layout for us is to have one dataset with maybe 8-10 cards built on it shared on a single page. We want our users to be able to drill down in those cards and to eventually reach a "base table" that does NOT include all…
-
Exporting Dataset as CSV ignores the Round function
Hi, I have a dataset that I need to extract. In the ETL, I round the column to 2 decimal places. When I extract the data and open it in MSExcel, I see the 2 decimal places. However, if I open it in notepad, I see multiple decimal places. How can I avoid this to happen? Any advice would be appreciated. Thank you.
-
DOMO Org API
Leverage domo's company organization to get user's peers, users that report to them, and users that they report to. Currently User API and Group API does not get a company hierarchy. Having the ability to get some one's manager or to get a list of users that reports to some one would be extremely useful for a lot of…
-
How to Display Repeated Values in a pivot table?
Running into an issue where a pivot table suppresses a repeated value while in a different group. In the image, I am needing the Care Level "CS" to display "Enhanced Studio" in the "Unit Type" column for unit 237. Currently it is suppressing since the above value is the same… Anyone know how to do this? Thanks!
-
Export Magic ETL Code for External Version Control
In our current environment, we use an external repository (Bitbucket) to maintain version control and the ability to run detailed diffs before making changes to our SQL dataflows. It would be helpful to have a way to export either the code or some representation of the current state of a Magic ETL dataflow to be used in…
-
Syntax issue for the beastmode concat ( text column)
I am currently having a column with different data types ( there are null, text, percentage -ve numbers, numeric values ) indicated as text column. The dataset displays %, -ve values. However , when cards are created, they only display the numbers but not the %. I tried creating beast mode for certain rows, however i get…
-
Auto ML for the Azure Platform
The current Azure platform doesn't support Auto ML, we have a couple of use cases to which we would like to apply Machine Learning and would love to use this feature. To apply any ML models currently, we would need to work with Jupyter Notebooks to R&D a model and apply it from there.
-
Is there a method to upload files directly to a Domo Brick?
I’m working with bricks and trying to upload files directly to a brick on my dashboard to use in my ETL. I want to understand the correct process for uploading files and if there are any specific configurations or APIs involved. Currently, when I drag a file into my brick, the 'file-name' section in the HTML updates to…
-
facebook advanced connector
anyone used facebook advanced connector? Is this for facebook organic tracking? Question about "Page Posts" and "page post lifetime metrics" reports, if selected same time period, should "likes" in "page post" = "total likes" in "page post lifetime metrics"? I got different numbers. What is included in "total likes"? Thank…
-
Create Bar Chart with Current Month Vs Previous Month?
I have a data set of invoices that I want to compare in a bar graph where one bar is October and the other bar is November. I suppose I can do this with a beast mode but I think my syntax is off. Case when Title LIKE '%OTT%' Then 'OTT' AND MONTH(Date) = CURRENT_DATE(MONTH(Date)) THEN 'Current Month' Case when Title LIKE…
-
Horizontal orientation for Radio button list to occupy less space in forms.
Hello Team, I am trying to build a form in Domo Apps and used the radio buttons as options, I have 10 options in my list and by default they are placed one below other and hence the length of the option section has increased. I wanted to place them horizontally so that it takes less space as radio buttons. Please suggest.…
-
Dynamic CAGR formula?
I know how to do a basic CAGR formula between two static years: power((sum(CASE WHEN Fiscal Year = 2024 THEN Amount else 0 end) / sum(case when Fiscal Year = 2020 then Amount end)), 1 / 4) -1 Is there a way to construct a CAGR calculation that responds to user filtering or changing the timeframe? I am trying to think of a…
-
What's the trick to get a microsoft sql connector to work?
I've tried everything I can think of and it still rejects my connection. I know that the database is up as I'm currently working in it in SSMS - I added the Domo IP addressed to Azure - so it should allow the connection in. What else do I try?
-
OR condition in QuickFilters
Ability get have OR filters in QuickFilters for dashboards.
-
Date Calculation
How do I write a calculation to return the same date but for next month? For example, if the date showing is December 4, 2024, how do I return January 4, 2024?
-
error while converting text to integer/float
I have a column that is a text column has values in %, $ and -ve values as well. I tried replacing the % ,',' and '$' to have only numeric values to convert it into a float or integer column. However I am getting the below error. What can I do to convert the numbers into numeric column so that I can apply calculations to…
-
To re-enable sort and reverse sort on the Pivot table
A customer via product feedback, would like to request that Domo re-enables the capability to sort and reverse sort on value columns when there are multiple fields in the "rows" area and subtotals are turned off. So I thought I should post it here on behalf of them. "I used to be able to sort and reverse sort on different…
-
Filter card always have a value selected?
I have a beastmode called 'Flagged' (value 1 and 0), and I use the BeastMode to create a filter card and then add that filter card to an App. Is there anyway to have 1 or the 2 value always selected? So it's kinda force the users to always select 1 of the 2 options
-
Set User Landing Page / Mobile Landing Page to App Studio App
Currently, can't set user landing pages on mobile or desktop to an App Studio app. This functionality would be very helpful with driving adoption of new products we've built using app studio.
-
Can an App be set as the default landing page?
Has anyone found a way to have an App be the default landing page for a user/group/instance upon logging in to Domo?
-
Drill Path error
Hello, need help if anyone knows the reason what could be the reason for this error message: I am using drill path and this is the visualization I want to make: This is what drill path in my DOMO looks like: For Reports 1 and 2 - I use the same dataset which is "View of loss" For Report 3 I changed the dataset and used…
-
LinkedIn V.2 Connector account issue
Has anyone had issues with the LinkedIn V.2 connector in recognizing or pulling organizations they're linked to? When I try to set up the connector no organizations show up in the Organization ID drop down, and I can't find much documentation on the connector page about any prerequisites for the connector to work. I'm set…
-
Alert / Notification setting
Hi, I created a dataset using the email connector, and some of my colleagues are also sending data via email. Is there a way to send them a notification to confirm that the data they sent was received? I checked the notification settings, but I only see two options. Can you please guide me on how to send notifications for…