Best Of
Variables Use Cases & Feature Walkthrough
Domo's Education and Product teams have provided this video diving into Domo Variables use cases.
What can be found in this video:
- What is a Variable in Domo?
- Two use cases that illustrate some of the solutions that Variables provide.
- How to implement Variables in your own cards and dashboards.
- How Variables can replace static dashboards with interactive data experiences.
Make sure to like, share, and subscribe to Domo's YouTube channel to be the first to know about these helpful videos in the future.
Re: Is there a way to combine/transform a Date&Time column into Domo?
That's how dates data types are formatted within Domo. If you're wanting to change the format you can use a DATE_FORMAT function in a beast mode to convert it to a string by passing in the appropriate formatting string. See https://www.w3schools.com/mysql/func_mysql_date_format.asp
As for calculating the differences between two dates I've written up a post about this here: https://dojo.domo.com/main/discussion/52682/domo-ideas-conference-beast-modes-time-difference-formatting#latest
It'll get you close to what you're wanting to do. You'll likely want to remove the FLOOR function since you're wanting decimal places instead of whole elapsed days. You can replace it with ROUND(..., 1) to round your value to one decimal place.
Re: Data Type Reference in Datasets
You can get a list of the available column types from the pydomo code: https://github.com/domoinc/domo-python-sdk/blob/dacdee87d9e798f4c83f270b38c8ea2b1b6c7923/pydomo/datasets/DataSetModel.py#L16
Re: Export Dash as PDF from button in UI
Hi @wilbaile ,
One option you have is to put their emails so schedule a report to your clients each day, week etc. It will just be a picture more than a PDF, but you can attach the underlying excel file as a table if you need.
Your BEST option though seems to be to just allow exporting on your embed options. Here's a video I made of your possible solutions: https://www.loom.com/share/2038362b634a42389dfcb59b7aef8b33
Good luck,
John Le
More videos at https://www.dashboarddudes.com/pantry
Re: Show last 12 months dynamically using beast mode calculation?
If you must use a beast mode one like this should work for your use case:
CASE WHEN `dt` >= (CURRENT_DATE - INTERVAL (DAYOFMONTH(CURRENT_DATE) - 1) DAY) - INTERVAL '12' MONTH AND `dt` < (CURRENT_DATE - INTERVAL (DAYOFMONTH(CURRENT_DATE) - 1) DAY) THEN 'Include' ELSE 'Exclude' END
I've outlined getting the first day of a month in another post which will explain this in more detail:
I've also presented on this topic as well and you may find this video useful: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6
Re: Data imputation
Hi @zuchu ,
So you need to make a lookup table and then write a formula to say when your location field is blank to pull from that lookup table, otherwise just keep the location formula you originally had.
I made you a video to make this easier to follow: https://www.loom.com/share/421ffb74198345c49ae466c851a1d103
Good luck,
John Le
Re: Select multiple cards at once in design view to change background colors
Would love to also see select multiple or DEFAULT SELECT ALL for Change Interaction > Open card details in new tab !!
