-
Excluding Current Month (but on a different fiscal calendar)
Hi - we work off a broadcast (Monday-Sunday) calendar and was wondering if there was a beast mode that can exclude the current month? I've tried a few versions found on the dojo but since I'm checking "use fiscal calendar" on my graphs (eg: bar chart) it seems to not function correctly. Eg: Case when Month(`Date`) <=…
-
Simple DATEDIFF Question
As I understand it DATEDIFF will return (in number of days) the difference between two sets of dates. My dataset is pretty rudimentary so it seemed pretty cut and dry but when I do DATEDIFF (for days) it returns an incorrect figure. This is the beast mode I am using: DATEDIFF(`Form Complete Date`, `Form Sent Date`) I…
-
Summing Up Last 12 Weeks Beast Mode
Hi There, I am trying to do write a beast mode to sum up Revenue from the Last 12 weeks but not counting the previous week. for example Last Week = 11/22 - 11/28 (Sunday - Saturday) I want to go back 12 weeks from last week, so I would start from the Week of 11/15 This is what I've come up with but it doesn't seem to…
-
Beast Mode to compare Values in 1 Column against 2 time periods
Afternoon, I have access to a dataset at my organization that pulls in competitor data. The question I want to answer with my card is: * Who is/are the new competitor(s) that showed up last week (fully completed week) compared to competitors from last 12 weeks (exluding the prior completed week) I have built out a dash…
-
Multiple Case Statements
Hi Everyone, I am having a bit of trouble stringing together multiple case statements... The end goal of my attempted beast mode is to calculate Average Weekly Cost Per Lead (CPL is Cost divided by # Leads). The wrench in this whole scenario is that I have to do this based off the broadcast calendar. Broadcast Calendar is…
-
Dynamic "Series" in a line chart
Hi Folks, Let me try to explain this as clear as I can since the subject title is sort of not clear. For context, my role is card builder within my organization. I am putting together a dashboard that is related to SEM Competitive insights using google auction insights data. This is my default view of my line chart. Here I…
-
Conditional Formatting Workaround in Pivot Table
Hello, Context: In my organization, my role is cardbuilder. I have built a pivot table and ran into some issues with conditional formatting. In my table, I have Daily Budget and Net Cost as two columns broken out by day. Ideally, I wanted the Net Cost column to turn RED (could be font or background - just something to flag…
-
Custom Sorting
Hi Everyone, I followed the steps outlined here: https://dojo.domo.com/t5/iSolveditwithDomo/How-do-I-Create-a-Custom-Sort/m-p/45500#M13 but cannot get my custom sorting to work. Chart: Heatmap Data: Google Ads Data, broken out by date and hour. I attempted to do custom sorting for Day of Week (using a date transform) and…
-
Creating a Pivot Table Card where the default view is COLLAPSED
Hi Everyone... First post here. Just finished my professional cert level 1 to give you an idea of knowledge level. I created a pivot table chart and by default I have a QTD date range broken out by weeks. My column hierarchy goes -> Week (based on our fiscal calendar) -> Campaigns -> dimensions/metrics. We might be running…
-
Percent/Absolute Change WoW as a Beast Mode Column
Hello, I am a cardbuilder for my organization and I am having a tough time getting a Week over Week beast mode calculation correct. Our calendars are set on an admin level so the fiscal week is Monday - Sunday. In the screenshot attached, I want to show the % change WoW for the metric "Clicks". I want it so it will…
