-
Bar Graph of Open Orders between Start and End Dates
I am trying to create a bar graph that will show number of open items by week or month. The data has an order with a start date and end date, and I am hoping to create just using that. The way I am doing it now, is joining with a calendar in MagicETL, but was hoping there is a way to do right on the original data.
-
Bar Graph Sorting
I am trying to create a stacked bar chart and sort by total sales. I have a field in the legend so I can see the composition of total sales. For some reason it is not sorting the chart descending by total sales like expected. What am i missing here ? setup: as you can see I have sales dollars descending in the sorting yet…
-
Favorite Chart Type Collection - A New Dropdown Option
Hello! Has anyone ever wanted a new dropdown option in the Chart Type area for their favorite/most used charts? It would be helpful to have vetted chart types used for specific purposes in one place. Furthermore, it could also serve as a collection of "approved" chart types for business units. Would anyone else find this…
-
Action Type Query Parameter
Currently working the audit API and noticed that I cannot add actionType as a query parameter. I would like this feature to be added so I am able to pre filter the data prior to download. Thanks!
-
Filtering on Null Values
I have seen this question/idea opened and closed several times but I will submit again that a user being able to include or not include null values with a simple filter is important. I understand the ETL and beastmode workarounds but it is not scalable to have every request run through a limited data team just to find out…
-
Turn on Gradient Colors Feature for Heatmap
The new 'gradient colors' feature should be turned on for the Heatmap card, so you're not stuck with the default themes. It seems weird that the one card that requires gradient colors can't use the same same options as cards that don't have to have gradients.
-
Moved: DOMO Org API
This discussion has been moved.
-
Beastmode Error - An issue has occurred during processing.
I am trying to create a simple beastmode to calculate the last week vs 6 week weekly average variance with the calculation below and I keep getting this error message. I've tried troubleshooting but I can't figure out why this isn't working. Can someone help me look into this? CASE WHEN SUM(CASE WHEN Year Scenario Rolling…
-
Why are filters showing on one embed dashboard and not the other?
I have two dashboards that are currently actively embedded and available to the end user. Both of these dashboards are embedded on our internal portal via iframe. One of the dashboards does have a filter showing when you hover over the top right corner and the other one doesn't. Can someone help me understand why? I've…
-
How to include nested folders in S3 advanced connector
Hello. I am trying to set up the connector that would fetch the data daily from S3 bucket. I am working on an advanced s3 connector as it seems to have a more intuitive way to grab the data. My S3 schema looks like this: `s3://adtech-third-party-data/AmazonA9/2021/09/` In DOMO settings credentials, I put…
-
Getting value of previous quarter and comparison
Hello Team, I have a date column named 'Fiscal quarter start date' and another Beast mode with calculated value for 'Customer Survey' I want to create a beast mode in which I will compare the Customer survey of the Current Quarter with the second last quarter. I tried to create a Case statement but unable to get results…
-
Error messages on embedded cards
We need the ability to control the error messages and report issue button when cards do not load in the embedded environment. The report issue is problematic as the end user assumes that the issue will be reported to their support group, but it does not.
-
How to make the math right with variables as filter
I'm using variable as the filter for a dashboard. Basically I created variables named "timeframe" with values of Month, Quarter & Year On the breakdown, it works perfectly with timeframe as dimension. However, for the summary card, i used timeframe as the filter with the below SQL Funny thing is if I pull out sum('Budget')…
-
Appstore Submission Enhancements
As someone who would like to create more submissions on the Appstore for other Domo users I would like to have any easy way to do and see the following. Understand how many times my submission has shown up in searches. Understand how many users have clicked and viewed my submission. Receive and answer questions about my…
-
Mapbox Pick List Brick Works in Preview but Not When Saved
Hello! I installed the Mapbox Pick List Brick app and adapted the code with a custom dataset. When I use this code in the editor, it runs and works in the preview without issue. Once I save it, the map and list elements fail to load. I copied my code to Fiddle for reference: The gif shows what I see when I'm building and…
-
Description for Calculated Fields
I would like to have the ability to attach a description to a Beastmode field similar to what we can do with a regular field when viewing a dataset in the data center:
-
February 2024 Community Forum Highlights
Hello Domo Community! Last month’s highlights are another example of the top-tier collaboration and support found within our community. We’re excited to share what you’ve been able to accomplish and shout out some members and discussions that stand out! Before we begin our highlight dump, we want to say just how ecstatic…
-
Apply color rules to variable values
When working with variables, it would be a great feature to allow to set color rules for all the values in the fields within the variable. This way, when the variable is applied in more than one chart in a dashboard, we can easily spot trends or make comparisons within the categories. For example: For a variable that…
-
Add Distinct Count to Summary Number
It would be nice if Count Distinct was an option in the Summary Number aggregation options to quickly show a distinct count. Right now, I have to create a beast mode for this number to show up in the Summary Number choices. It would be a nice timesaver if it was a built in aggregation choice.
-
Running Total
Hello, I need help. Wondering why my running total is failing. I have the logic set up in the dataflow. The card returns the the correct value in months where there was production but for months with no activity, the value is skipped but returns the right value in the subsequent period. How do I resolve this? Product mon1…
-
S3 Advanced Connector Not Loading JSON Files
I'm trying to automatically load all files ending in ".json" from an S3 bucket using the S3 Advanced Connector. However, no data is loading. I set the File Name field to ".json" and the File Name Match Type to "File name contains the specified string." I have no problem reading individual files from this bucket without a…
-
Period over period cards interactions with filters
Hi All, In one of my reports we're using a dataset that refreshes daily but at the end of the month we have to wait a few days for pricing on accounts to settle so the report will re-run the prior month position until rolled forward. The issue I'm having is when it comes to the end of the month all of my cards that are…
-
Using Email in Jupyter Workspace - Python Scripts
Hi All, I was trying to trigger and send emails from the Jupyter workspaces. I have the list of emails to whom I need to send and I also have the subject and body of the email ready, but I'm not able to connect to the DOMO Notifications Email which is being used by Card alerts and Workflows to send out emails. Is there any…
-
changing a column data type
Hello community, I have a column that has dates yet the data type for this column is showing as a 'text'. I've been looking everywhere, but I don't see any options that would allow me to change the data type for this column. Where can I find the menu to change a columns data type? Is this even possible in domo? Thank you!
-
Card Error Report
It'd be useful to have an ability to build real-time reporting around which cards are broken. The existing DomoStats Card Loads dataset is more of a log of card load performance, and the fact that there's no datetime value does not allow to tell that card X's last log is a failure. Given this limitation, it cannot be…
-
Data never sleeps turns 11!
If you’re new to the Domo on Data-verse, this is our annual report that captures the world’s data usage by the minute. If you're a data nerd, you'll want to read up on the latest article by Domo's Senior Director of Strategic Architecture, Jace McLean. Read here: Data Never Sleeps Turns 11!
-
Recover a deleted dataflow
Hi, I was doing some cleanup and deleted some datasets that resulted in the deletion of a dataflow. Is there a way to recover deleted dataflows? I noticed a deleted dataflow could be recovered if you find a link to it: —but I can't find a link to the dataflow I need. Thanks.
-
SUM(distinct) Fixed By
I have a column that needs to be a constant value based on two more columns. So I am using this formula SUM(DISTINCT Balance) FIXED (BY Client, Item). This is working fine. However, When I am using the same formula in another beast mode I am getting the below error (1-SUM(Lost))/ sum ((SUM(DISTINCT Balance) FIXED (BY…
-
Is there a way to add more dataset slots to a DDX brick?
I need to add more dataset alias slots to my DDX Brick, but I can't seem to find where to do this. Does anyone know where and how this is done?
-
Mass Alias Column Names
I have a dataset with a few hundred columns to alias. Is there a relatively painless way to do this without using the select or alter tile?