Best Of
Re: YTD BeastMode with Variables
I don't have an example set up to try this.
SUM(CASE
WHEN (
(Year Selector = Fiscal Year AND Month Number >= 2) -- From February to December of the current fiscal year
OR
(Year Selector = Fiscal Year + 1 AND Month Number = 1) -- Include January of the next calendar year
)
AND Month Number <=
CASE
WHEN Month Selector = 'January' THEN 1 -- Stop at January for Year Selector = Fiscal Year + 1
WHEN Month Selector = 'February' THEN 2
WHEN Month Selector = 'March' THEN 3
WHEN Month Selector = 'April' THEN 4
WHEN Month Selector = 'May' THEN 5
WHEN Month Selector = 'June' THEN 6
WHEN Month Selector = 'July' THEN 7
WHEN Month Selector = 'August' THEN 8
WHEN Month Selector = 'September' THEN 9
WHEN Month Selector = 'October' THEN 10
WHEN Month Selector = 'November' THEN 11
WHEN Month Selector = 'December' THEN 12
END
THEN IFNULL(Amount * -1, 0)
ELSE 0
END)
Re: YTD BeastMode with Variables
What if you change January to 13 instead of 1? That should cause it to treat January as part of your fiscal year Feb 2024 - Jan 2025.
Re: Can you add an 'Export' Button in App?
I don't think there is a direct way to programmatically add a custom button inside a pivot card to trigger an export. But you can probably do something similar through a custom card or app.
Re: Can you add an 'Export' Button in App?
It's funny, on an embedded app, you can "allow export" which surfaces the Export button to be right next to the "expand for detailed view" button, which is way easier to find for users. It would be nice if this was possible in an AppStudio app that was shared directly in Domo.
Re: Schedule App Studio Reports
Hello everyone!
App studio email report builder is currently under development. This will be ready for a Beta end of Jan 2025.
Re: Dataset column description mass load
You can do this via the API
STEP 1
Create a POST request to
"https://YOURDOMAIN.domo.com/api/query/v1/datasources/YOURDATASETID/wrangle"
in the header include the KEY - x-domo-authentication with the API key you get via POST REQUEST
STEP 2
"https://YOURDOMAIN.domo.com/api/content/v2/authentication" Body of Post will have
{
"method": "password",
"emailAddress": "JOe.Bloggs@MYACOOUNT.com",
"password" :"ROOT!@#$"
}
in the first Post call you will include your 800 columns in JSON you can extract the json via the dom when you change the description of a column and record the network traffic example below.
modify the descriptions and post it. Bit strange that something that takes 3 steps via api cannot be automated in domo
{
"columns": [
{
"name": "Last Date Published",
"id": "Last Date Published",
"type": "DATE",
"description": "Last date available in the data",
"visible": true,
"order": 0,
"referenceDataSourceId": "c7XXXXXXXX5-3ab1-4f45-9253-f9fy6bd094d",
"invalid": false,
"newName": "Last Date Published"
}
]}
Boxplot & Histogram Charts
Hello
I am just reopening an old issue reported here ( https://community-forums.domo.com/main/discussion/19106/boxplot-histogram-charts ) and closed some years ago:
The current limitation of 100k records for boxplots and 25k records for histograms makes those visualizations useless when dealing with sizable data, which is what these are meant to be for. The "Not all the data is shown" warning is appearing as soon as the source data passes those limits, making the cards dangerously misleading.
I can easily produce a table with grouped data showing min and max for each group, even if the data behind as some million rows. I'd expect boxplots not to be much more complex than that; just replacing those "min" and "max" with quantile metrics, Domo can produce all the math needed to draw the boxplot.
In some thread it was suggested to precalculate those quantile metrics in a previous ETL, either though SQL functions or with python or R code. This solves the problem for a static snapshot of data, but it lacks all the flexibility of interactive Domo filtering. At the end of the day, I don't need Domo to manipulate a static photo of my data, I want Domo to give final users all the analytical power to drill the data.
Re: Smart Text with many filters selected, best way to represent it for better users experience?
I try to group filtering and sort of summarize based on the groups:
Location: Dallas, New York
Type: Retail
And if no filtering is selected, display 'No filters selected'. Or you could try something on a single line such as :
🏢 Branch: Toronto | 📍 Province: Ontario | 🛒 Type: Retail
Join the Community at Domopalooza 2025 🪅🤝 Now open for registration!
The wait is over—Domopalooza 2025 is here, and this year, it’s bigger and bolder than ever. Domopalooza is the ultimate Data + AI conference, where the brightest minds come together to share, learn, and have a whole lot of fun.
Here’s a sneak peek:
- Brilliant minds (that’s you!) coming together for an explosion of insights.
- Workshops and success stories so good, you’ll want to take notes in ALL CAPS.
- Concerts, parties, and...
REGISTER NOW HERE.
And here’s the best part—if you register now, you’ll save $200 with our Early Bird pricing—because we believe in rewarding early action-takers.
Experience the collective brilliance of the Domo community for yourself in Salt Lake City, March 18–21, 2025. Bring your thinking cap, your party shoes, and maybe a pair of skis. See you on the slopes—and in the sessions!
Learn more about Domopalooza here.
Importing datetime values from Excel without a transformation
We've got a bit of a toolchain between some of our data and Domo:
Database --> Library --> Excel --> Workbench --> Domo
According to the Domo Excel Connector docs, Domo can handle a bunch of date, time and datetime formats automatically:
mm/dd/yy
dd-month-yy
weekday-month,dd,yyyy
m
m-dd
hh:mm:ss PM
hh:mm
mm/dd/yy hh:mm PM
So far, having no luck with datetimes. Pure dates can come in as dates, pure times can come in as times - but datetimes aren't making it in properly. They're either strings or numbers, not datetimes. To simplify testing this, I've abbreviated the path of the data to:
Excel --> Domo
I figure that if I can get this working, I can sort out how to do it back in our full environment.
Is there a way to set up an Excel worksheet to hold datetime values that Domo can interpret directly without any kind of transformation? The docs say that it's possible but, If not, I guess I'll use a Custom Date Format transform in Workbench instead of a DataFlow or Beast Mode to avoid any confusion in Domo with two different data sets. (We'll never need to chart with the badly interpreted datetime values.)
Thank you!