-
A more flexible way to do Period over Period comparisons
Greetings! I see variations of this topic asked several times so I thought I'd write up all of the information in a singular spot for easier reference. Below I'll outline how I utilize my own date dimension table to have customized period over period charts, compare the current partial month to the same amount of time in…
-
Domo Ideas Exchange - Beast Modes - First / Last Days of the Month / Week
Problem: How Do I calculate the start or end date of the week or month? Solution: Last Day of the Month: This is fairly simple as we can use utilize the LAST_DAY function which will return the last day of the month for the provided date. LAST_DAY(`dt`) First Day of the Month: For this we can do some simple math to subtract…
-
Domo IDEAs Conference - Beast Modes - Number Formatting
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to format numbers a number when concatenating with a string. Problem: When concatenating a string with a number the resulting value is a string and unable to utilize Domo's built in formatting. Solution:…
-
Allow for Min & Max in the Rank & Window Tile in Magic ETL
The minimum and maximum aggregation are standard calculations that should be included in the rank and window tile but currently are not. They should be added to avoid having to use a group by and then joining back to the dataset for simplicity and efficiency.
-
Variables - Dates - Min or Max Today
It'd be great to be able to set the min or max values for a date variable to today so that it restricts users to not select a future date or past date when required to allow dashboards to work correctly and protect against outlier dates.
-
Variables - Dates - Default Today
When using date variables we have to define a specific value, it'd be great if it would allow the selection of today as a default as I'm typically wanting to use today's date with the variables. This would also allow me to not have to keep updating the default date as it gets farther away from the current date.
-
Grant Smith - PraxisMetrics
Hello to the Domo Community! I'm Grant Smith, Data Application Architect at PraxisMetrics, a Domo partner consultancy. At PraxisMetrics I build and design different solutions on the Domo platform focusing primarily on the e-commerce sector. Previously, I've been in the healthcare, retail, e-commerce, and financial sectors.…
-
DP22 - Using Beast Mode to Build Data Storytelling - Formatting Text
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case: We wanted a way to allow our users to quickly visualize good or bad data results. To…
-
DP22 - Using Beast Mode to Build Data Storytelling
This post is the supplement to my presentation “Using Beast Mode to Build Data Storytelling” at my Domopalooza 2022 session. Over the course of that session I talked about several use cases and went over beast modes how to handle those use cases. I also discussed and talked about defining custom period over period…
-
DP22 - Using Beast Mode to Build Data Storytelling - Links and Images
This post is part of a series of beast modes I presented on during my “Using Beast Mode to Build Data Storytelling” Domopalooza 2022 session. If you find this post helpful please make sure to give it a like or an awesome below. Use Case We wanted to enhance the visualization experience and allow users to see which specific…
-
Domo IDEAs Conference - Beast Modes - Running Totals
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to calculate a grand total, running total overall and by month. Problem: How do I calculate a running total? Solution: We can utilize a window function which will calculate some metrics across the entire…
-
Domo IDEAs Conference - Beast Modes - Rolling Averages
Greetings! This is another post highlighting a beast mode from my Domo IDEAs conference session. This one covers how to calculate a rolling average. Problem: How do I calculate a rolling average? Solution: We can utilize the LAG function to get the prior X values and then divide the sum by the number of values. Lag:…
