Best Of

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 item we’re referencing with an image rather than just a specific ID code. Another think we wanted to do was to allow users to click on the image or hyperlink to go to the website to get more information on the product rather than having to look it up themselves. We utilized a Mega Table for this but the beast mode will also work in an HTML table if desired.

Beast Mode

CONCAT(
'<A HREF="https://my.url.com/store/detail/', `Product ID`, '" TARGET="_blank">',
'<IMG SRC="https://my.url.com/images/items/', `Product ID`, '-small.jpg"/>',
'</A>’)

Beast Mode Breakdown

Hyperlinks

CONCAT('<A HREF="https://my.url.com/store/detail/', `Product ID`, '" TARGET="_blank">@</A>’)

Generates HTML code to create hyperlink for users to click on by dynamically creating the URL with the correct product ID. For example: <A HREF="https://my.url.com/store/detail/SM58" TARGET="_blank">@</A>

TARGET="_blank" causes the link to open in a new tab instead of replacing the existing window. This is important because if it’s opened in a new window and a user clicks back to get back to the card they will lose all of their filtering. Opening a new tab allows the card to still exist with the filtering in place giving a much better user experience.

Whatever is in between the <A> and </A> tags will be highlighted for the user to click on and go to the URL defined in the HREF. In this example @ is the text that will be highlighted for a user to click.

Can only use mailto, http and https protocols in hyperlinks.

Images

CONCAT('<IMG SRC="https://my.url.com/images/items/', `Product ID`, '-small.jpg"/>’)
•       

Dynamically generate the URL of the image using the product ID For example: https://my.url.com/images/items/SM58-small.jpg

CONCAT wraps the dynamic URL in HTML IMG tag to tell the browser to display an image

Images & Hyperlinks

CONCAT(
'<A HREF="https://my.url.com/store/detail/', `Product ID`, '" TARGET="_blank">',
'<IMG SRC="https://my.url.com/images/items/', `Product ID`, '-small.jpg"/>',
'</A>’)

Combines the logic from the Link beast mode with the Image beast mode to allow for users to click on the image to open the link.

We’ve replaced the @ in the Link beast mode

Final Result

Clinking the image takes you to the webpage defined in the A tag's HREF URL.

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 needed a way to display and estimate in real time how well our sales were pacing for the current month to allow stakeholders to quickly make informed decisions. To do this we created a sales pacing graph to determine the current month’s running total and where sales are projected to be at the end of the month.

Beast Modes:

Running Total

SUM(SUM(`Daily Sales`)) OVER (PARTITION BY LAST_DAY(`Order Date`) ORDER BY `Order Date`)

Run Rate:

SUM(SUM(`Daily Sales`)) OVER (PARTITION BY LAST_DAY(`Order Date`) ORDER BY `Order Date`) / DAYOFMONTH(`Order Date`) * DAYOFMONTH(LAST_DAY(`Order Date`))

Beast Mode Breakdown:

Running Total

SUM(SUM(`Daily Sales`)) OVER (PARTITION BY LAST_DAY(`Order Date`) ORDER BY `Order Date`)

OVER denotes a window function. Window functions in beast modes are a feature switch. Talk with your CSM to get this enabled.

Window functions allow us to calculate an aggregation across the partition or entire dataset and return that value as a single value within each row.

PARTITION BY LAST_DAY(`Order Date`)

PARTITION BY Defines the bucket we want to aggregate over

Can exclude to aggregate over the entire dataset.

LAST_DAY returns the last day in a month. This is a way to group by each month. It’s an alternative to (PARTITION BY YEAR(`Order Date`), MONTH(`Order Date`))

ORDER BY `Order Date`

Defines the order in which to calculate the running total.

If excluded it will be the grand total within your partition.

SUM(SUM(`Daily Sales`))

Normal SQL is a single aggregation however Domo can potentially do aggregation twice. First when the data is initially loaded into the card. Another time when you have selected aggregation on another field on the card.

Because a window function returns a single value for each row we need to tell Domo how to aggregate the data (again) when the card does aggregation.

Run Rate

SUM(SUM(`Daily Sales`)) OVER (PARTITION BY LAST_DAY(`Order Date`) ORDER BY `Order Date`) / DAYOFMONTH(`Order Date`) * DAYOFMONTH(LAST_DAY(`Order Date`))

SUM(SUM(`Daily Sales`)) OVER (PARTITION BY LAST_DAY(`Order Date`) ORDER BY `Order Date`)

This is the Running Total beast mode from above. We want to get the month's total at the date given.

/ DAYOFMONTH(`Order Date`)

Divide by the day number of the order date (DAYOFMONTH) to get the average amount per day. In other words the number of days that have elapsed in the current month as of the Order Date

* DAYOFMONTH(LAST_DAY(`Order Date`))

LAST_DAY returns the last date in the given month. DAYOFMONTH will tell us the day number of the last day of that month. In other words, the number of days in the given month. Multiplying our average we just calculated will give us an estimate for the end of the month as of the Order Date value.

Final Result:

Unfortunately, when a table is the scheduled report, Domo is essentially taking a picture of the table card and including it in the body. It is a fixed width and can't be adjusted. It would be a nice enhancement if the full table card was included, though.

Is there any way to remove the sort symbol from view? It can be obstructive when looking at the axis numbers.

I can't find anything in 'Chart Properties' to disable it.