-
Week of starting on Monday
I am having trouble with a "Week of" beast mode. Domo has the ability built into the cards to group the data by week. It does not, however, allow you to pick the start of the week. Our client wants the week to start Monday instead of Sunday. I have been trying to figure how to accomplish this. The below code works for all…
-
Creating a join expression with multiple criteria
Hi, I am a little stuck trying to create a join expression. In the table below, I want to join the Cost using the active From date to a table of data with multiple dates. For example, I have data from 1/31/24 thru today. For Campaign 1, I want to use the cost of .5 up to 1/31/2025 and then moving forward after that, use .6…
-
Unique calculation
I have an issue where there is a campaign "Campaign 1" that needs to be split out into 3 parts; NHL, NBA, and NCAAF. NHL will get 40% of the impressions, NBA will get 40%, and NCAAF will get 20%. I cannot figure out how to break this into 3 parts and calculate the impressions. I have multiple other campaigns that I can…
-
Rank and Window Function - SUM
I am trying to create a SUM in a Rank and Window ETL Tile. I have no reason to put a Frame Range in other than unbounded but it will not let me APPLY. I must be doing something wrong. Should the FOLLOWING box be a 0?
-
Error with String to Date
I am having an issue with a column that looks like a date but for some reason will not convert to a date. I am trying to use String to Date but it keeps giving me an error. Any ideas?
-
Calculated field for before and after date
I have a calculation based on date that is only half working. CASE WHEN (DATE(Date)<'03/01/2024') THEN SS Revenue ELSE (SS Impressions*eCPM/1000) end In the formula, it is pulling in the correct amount when it is BEFORE 3/1/2024, but for some reason, it is returning 0 for anything after that date. When I look at the SS…
