Best Of
Re: How to show YTD data in Tabular format?
@SayyedHussain If you want to only include months to date you can add a beast mode filter like the one below:
case when MONTH(`Date`) <= MONTH(CURRENT_DATE()) then 'Include' else 'Exclude' end
Re: IN function
No you cannot. You would have to do: CASE WHEN `session_medium` LIKE('%Email%') OR `session_medium` LIKE('%email%') OR `session_source` LIKE('%Email%') OR `session_source` LIKE('%email%') THEN 'Email' ELSE 'Whatever' END
I would recommend using LOWER() function so you don't have to have both Email and email in your statement.
Re: Displaying Data on HTML Table with Pre-existing Formatting
I figured out a quick hack that works. Just posting here in case anyone else experiences the same issue.
I created a Beast Mode function to render, just by using a simple concat.
Now, when I reference my new field, it does what I need it to. I guess it just needs that little push to recognize the HTML?
Re: Adding Distribution List Column Value to Campaign for Each Email
I managed to figure out a solution for this problem. Basically, you can click on the "Add Merge Field" button and click on the field name to drag it to the location within the document or email body.
Re: If date falls within the current month
Hi @MThebeau
You may use the Domo Dimension.
Go to connectors and type dimension, It should look like the following screenshot
Re: If date falls within the current month
@MThebeau I would recommend restructuring your formula so that @colemenwilson's case statement resides within the denominator sum to ensure that all your conditions have the same granularity. Also MagicETL actually has a function in formula editor called DATE_WORKING_DIFF that calculates number of working days between two dates, so I would use that to hard-code the number of working days to date in the current month like this:
DATE_WORKING_DIFF(CURRENT_DATE(),CURRENT_DATE() - DAY(CURRENT_DATE()) + 1)
Then you can reference that new column in the final beast mode like this:
sum(`Total Billable Hours`)
/
sum(
case
when LAST_DAY(`Date`) = LAST_DAY(CURRENT_DATE()) then `MTD Working Days`
else `Working Days in Month`
end
)
Re: Filter Select: 2-day or 3-day data
Last 2 days:
CASE WHEN Date >= CURRENT_DATE() - INTERVAL 2 DAY AND Date != CURRENT_DATE() THEN 'Include'
ELSE 'Exclude' END
Last 3 days:
CASE WHEN Date >= CURRENT_DATE() - INTERVAL 3 DAY AND Date != CURRENT_DATE() THEN 'Include'
ELSE 'Exclude' END
Re: Filter Select: 2-day or 3-day data
You can use Michelle's suggestion to exclude today dynamically and then you can use the date range filter on the card and choose last 3 days or last 2 days, which can be easier to maintain and is an easier visual cue for the end user to know the data range of the card. It also allows them to change it to other date ranges, if needed, while still excluding today with the Michelle's beast mode.
