-
UTC to PST conversion in ETL
Hi, I am trying to convert the "Date" from UTC to PST in the ETL. Currently, I created "Send Date PST" with the formula below. TIMESTAMP((convert_tz(`SendDate`, 'UTC', 'America/Los_Angeles'))) However, when I try to use it in the card and filter for the last 4 hours, my card is blank: It works when I do the same thing with…
-
Selective filter settings on the dash
If the Domo dashboard filters can allow specific filters for selective cards on a dash level, that'll be a useful feature! I understand that we currently have the "Change Filter Exceptions" editing feature on a dash level to either filter the card on a dash level or not but I think we should have more than that. For…
-
Add dynamic columns in variable dashboards
If Domo has the option to add dynamic texts in columns, that would be super helpful for variable dashboards. Currently, I have variable buttons of TY, LY, TW, Last 2 Weeks, etc, and Spend 1 and Spend 2 as column titles but if we can have TY Spend and LY Spend and TW Spend, etc. as the column titles, that would be an…
-
Beastmode Error - An issue has occurred during processing.
I am trying to create a simple beastmode to calculate the last week vs 6 week weekly average variance with the calculation below and I keep getting this error message. I've tried troubleshooting but I can't figure out why this isn't working. Can someone help me look into this? CASE WHEN SUM(CASE WHEN Year Scenario Rolling…
-
Beastmode to decide how much to spend per ad in a given category
We have a working beastmode that calculates what ‘n’ should be depending on spend, revenue, and page depth (page depth is in 3 categories – all pages, product, and shopping cart). Here is the formula: = 1 / ((spend / revenue) / (sum (all spend per category)/ sum (all revenue per category))) Note that the category of all…
-
Rank Top 5 of the week
I am trying to solve 2 things and would really appreciate your help. When I take out the Sorting filter for SUM of Quantity and Fiscal Month with week (No Aggregation), the number of quantity changes, and the number of products per week also changes. This may be a data issue but is anything odd in this card? Before: After:…
-
Beastmode filter to show when data exists in both datasets
Hi, I am trying to create a beast mode where if a campaign name matches in both Dataset A and Dataset B, then name the filter 'Match Campaign Name' and everything else 'Doesn't Match Campaign Name'.
-
WOW comp calculation not correct
Hello, I am looking at this Domo Card and the WOW Comp calculation looks incorrect. Last Week Spend is $0 and Spend 2 weeks ago is also $0 but WOW is not 0%. Does anyone have any idea why this can be the case? For reference: LW Spend calculation: sum((CASE WHEN ((FY Order = 0) AND (Fiscal Week No = (Current Week - 1)))…
-
Beastmode subtotal not calculating correctly
Hello, I am trying to figure out what is wrong with my 3 beastmodes. One for this year's email sends, one for last year's email sends, and one for this year vs last year's difference. Currently, the chart looks like this and the beast mode doesn't seem to be calculating correctly in each row plus the subtotal. This Year…
-
Grand Total summing the percentage instead of calculating
Every time we bring in any kind of calculated difference to the table, we get a grand total that sums up all the percentages. For instance, for this Table, the rightmost column is calculating the difference between the two left columns. Every row is correct except for the Grand Total which sums up the percentage together…
-
API Connector update via Email/Announcement
Whenever there's an API connector update, it'd be nice if we can opt-in to receive the updates via email or some form of communication. Recently my team has been working off of the Facebook and Pinterest API connectors and when the API updates, it would change the column names which is problematic for us.
-
Does anyone know a Regex that only accepts a segment with a number before 'k' and nothing after?
Does anyone know how to create a Regex that only accepts a segment with a number before a 'k' and nothing after? Or it can be a regex that replaces everything that doesn't have a number before 'k' and nothing after with an empty string. I am looking to extract the circ value for our email campaigns but some rows have a…
-
Comment and Save Versions for Beastmodes
It would be great if beastmodes had a comment and save version function just like when we update dataflows. When we update the dataflow (in Magic ETL), it really helps to have the comment section for version updates. If we have something similar for beastmodes, it would be helpful as we can understand why certain…