Best Of

@LiliRestrepo adding the target="_blank" argument in the HTML code should do this for you.

It would look like this:

CONCAT('<div><a href="', 'https://yourinstance.domo.com/datasources/', `Dataset ID`, '/details/overview', '"', '"target="_blank">', `Name`, '</a></div>')

^^This is one I use in our instance to provide a clickable link on dataset names.

Hi @cbreen, a couple edits to your formula:

• When you have multiple conditions you need to check, you can simply contain them with a single CASE...END. Instead of repeating "CASE", you can specify each new condition with WHEN
• You are correct that your current formula does not account for September. You can add this as an additional condition

Try something like this:

case 
when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then 1
when month(`date_purchased`) = 9  then 1
when month(`date_purchased`) = 10 and DAYOFMONTH(`date_purchased`) <= 10 then 1
else 0 
end 

@cbreen You'll want to modify it to the following:

case when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then ( 

case when month(`date_purchased`) = 10 and DAYOFMONTH(`date_purchased`) <= 10 then 1 else 0) else 0 end

This will say if the date is after 8/11 then look at if it's before 10/10 and if it is then 1 else 0, but if it's before 8/11 then also 0. Since you're wanting to evaluate the second condition only if the date is after 8/11, then you need to nest the second condition in parantheses.