-
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…
-
Join Domostats with federated Outh dataset
Can we have an option to join domostats with federated Outh dataset in domo. Currently it used to throw an error while joining them in domo ETL.
-
Salesforce Advanced Connector Datasets Not Updating
Hi, I have the following datasets that use the Salesforce Advanced Connector: 45a359e1-5f9e-4877-9e36-535dc45812a5 a46fe459-e856-44e2-8491-7699efcad941 Today, when running these datasets, the changes from the Salesforce side are not reflecting, despite the dataset running 'successfully.' The Data Preview seems correct but…
-
Finer controls for IP Address Allowlist
There were recent changes to the IP Address Allowlist configuration that caused API integrations to fail. Currently, there is a single switch in the Admin settings for configuring the allowlist. If it's set to ON then the IP Address Allowlist applies to Mobile, Workbench, and API Clients. While this security feature is…
-
Drillpath to an existing card
Hello, is there a way to drillpath to an existing card using beastmode or any other domo features that might work? Thank you!
-
Allow ONLY HEADER text to wrap in table card
Please give us a chart property for mega tables to allow ONLY HEADER TEXT to wrap. Allowing the whole thing to wrap can cause uneven sized rows, which is really hard to read. But, a longer header can cause a wider-than-needed column. I've played with setting the column sizes via chart properties, but that can cause headers…
-
Adaptive Insights
Has anyone had success connecting to the adaptive insights connecter by authenticating through workday? We have gotten an error that our JWT token is not correct but there is no JWT token credential needed to connect. Any ideas?
-
How to resolve dead space area on a Dashboard?
While creating and editing a new dashboard and cards, somehow, I managed to create a dead space that seems to be un-editable. I can't add cards or do anything in this area no matter what I have tried (moving cards to appendix, removing cards things around the area, manipulating size and borders, refreshing, etc.) and was…
-
Pill formatting for Variable
Hello, I use Pills for Filters frequently. I'd like to use Pills for Variable controls as well.When using Pills for filters, I create a card and enjoy the format options in Analyzer, such as to center and fill Pills with the content. How can I achieve this using Variable controls? I have not found an Analyzer for variable…