-
Global date range filter in dashboard, have it compare to exactly a year ago in guage card type.
I have a dashboard that displays metrics from social media platforms, and I would like to apply global filters so the client can filter specific dates, but then also show what those values were exactly a year ago. Example: Say the client wants to see total impressions for April 12-17, 2023. I would like the card to filter…
-
Is there a way to duplicate a value one row down?
I have a column with a numeric value and null value every other cell. I want to replace the null cells with the numeric value that is directly above it. Thanks in advance!
-
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)))…
-
IF Statement Inside Beast Modes
Currently, you can use the IF statement inside of DataFlows (both MySQL and Magic ETL v2). However, this function is not available in Beast Modes. Most CASE statements I write are small and simple enough (they only have two outputs) that I could write them in an IF statement. IF statements are simpler to write and take up…
-
Append Output dataset help
Hello all, I have an Magic ETL (A) that with a output dataset - say OUTPUT_1. What I am looking for, is when every time I run the ETL, I need the output results to be appended. At the same time it should not create duplicate records. I created a new Magic ETL (B) with this OUTPUT_1 as input dataset and outputted to…
-
How do I Compare Column A vs Column B in the same Value?
I have one value that goes back several years and id like to compare TY vs PY. How do i write the calculation in beast mode to subtract A vs B and finally show the % ∆? Thank you.
-
Question on Domo SQL syntax
Hello all, I am trying to do Magic Transform using SQL option. I have embedded a SQL query but it is erring as it is not compatible with Domo syntax. Appreciate your help in this regard. DATE_PART('WEEK',CAST(TO_CHAR(TO_DATE(TO_CHAR(PRODUCT_KEY),'YYYYMMDD'),'YYYY-MM-DD') AS DATE)) AS "SaleWeek",…
-
Date Transform
I Have a year and a month column in my dataset which are in the format of integers. I want to create a beast mode calculation to concat them and have them as a date field. How can i do that?
-
Beast mode calculation
I want to create a beast mode calculation which should be something like this Value for current month this year - value for current month last year / Value for current month last year How can i do this?
-
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…
-
Omitting rows in pivot table
Any way I can omit this section in a pivot table but keep the 2021 Total?
-
Totalling certain rows
I have a question about totaling data in tables. I have two sets of data from different time periods 2021 & 2023, and I'd like to sum the respective metrics for each. I have two different tables present that may aid in getting this solution done. For the first image I want to add a column after the 2021-12-01 column to…
-
Case Statement with YTD
Hi Folks, I'm trying to derive this through Beast mode calculation. Requirement: Case statement Score 1 - If my error % is 0 - 75% Score 2 - If my error % is 75.1% - 95% Score 3 - If my error % is 95.1% - 100% (Includes 100) Score 4 - If my error % is 100% (YTD) Finding difficulty in writing a case statement for 'Score 4'.…
-
Change value formatting based on KPI selected in variable
I have a card that allows the user to select which metric (Sales, Units, Margin %, etc) they want to graph by, using a variable control. Is there a way to force data formatting to be 'currency' when 'sales' is selected for example? Then when a user selects 'units', we'd want the formatting to now be shown as 'number'. With…
-
FIXED BY Beastmode trouble shooting
Something is not working quite right and I am having a hard time figuring out what is going wrong. We're trying to see the % of registrations by year, by day of week (sun, mon, tue, …), by hour of day, and then to be able to filter by locations. So in ETL, for the numerator, I am grouping by Year, DayOfWeek, Hour of day,…
-
What function will help me determine a variable part of text?
I'm using Magic ETL to create a new column that will return True or False depending on the contents of a string in another column. Question is how do I write a Case formula that will return True or False based on the contents of another column? For example, the word "Delivery" is placed in different locations on a string…
-
SQL partition password reset
Hi - I put in a help ticket without success so far. We are using a SQL partitions connector to bring in accounting data. Following an apparent password reset on database access, some of the datasets continued to work while some larger datasets stopped working but continued to bring in blank lines of data. I reset my…
-
Aggregate counts over time that keep a running total
I have an area chart where time is the x axis, and count of instances are the y axis. I want the count to be a running sum over time, but I am not sure how to do that in domo. See my image for details. (I don't care about the trend line.)
-
I am using this beast mode but it wont let me save the card
count(ID) over(partition by Clinic,Product)
-
Number format
Hello all, I am trying to replace the Number format in Card/Dashboard. For example: Number is displayed as 21K but I need it to be full number with comma separator. Or 1.19K should be displayed as full number instead of 1191? I tried all ways but it does not seem to change the format. Can someone help me with this?
-
Formulae function for table instead of line by line
I have two tables. The first table i have a list of telephone numbers. The second table, a list of the first 3 digits of the number. I want to qualify the first with the next. Here is my formulae: case when SUBSTR(Phone,4,3) not in(NXX) then 'no' else 'yes' END so this is fine in that it qualifies line by line. However, I…
-
Column created with Beast mode with numeric and porcentage format
.Dear community, this month I have receipt separately two cases with the same concern: The users have shown to me functions created with beast mode, inside a pivot table card. The goal is set in the same column figure with number format and percentage, including the symbol “%”. I have attempted so many ways, but I don´t…
-
Is the data restricted for drill downs?
I am building a drill-down but seem not to have the same options as I would building a separate card. Example: I have a stacked bar overview where I am demonstrating the cutomer base by volume over months and by customer types. I am trying to create a drill down where I am showing in a pivot table view where I want to show…
-
Is there a way to bucket columns similar to excel in DOMO?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
-
Single Value Card Division
I have two single value cards. Card 1 is a overall total of all possible values and card 2 is a filtered subset of card 1. Is there a way I can divide the two cards? I know that you can just make a new beast mode with both calculations (Ex. Card 2/Card 1). However that does not work in my case due to Card 2 being a…
-
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…
-
Is there a way to store a beast mode in a filter on a dashboard?
Is there a way to instead of having the beast mode in our cards for the guage multi value visual (Impressions, Web Page Visits, Visit Rate, etc.), have it in a filter that links to the cards in the campaign? Instead of having a static last 30 days vs previous 30 days, our client suggested that it would be great if there…
-
Case statement with multiple conditions
currently I have this query and I have 16 exclusion reasons. Is there a more efficient way to write this beastmode? CASE WHEN exclusion reason 1 IS NULL THEN CASE WHEN exclusion reason 2 IS NULL THEN CASE WHEN exclusion reason 3 IS NULL THEN CASE WHEN exclusion reason 4 IS NULL THEN CASE WHEN exclusion reason 5 IS NULL…
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…
-
Filter metric by Beast mode dimensions
I have a Beast mode that configures source and medium dimensions into broad categories because Google's default channel grouping dimension is incomplete. (CASE WHEN Session Medium LIKE 'cpc' THEN 'Search' WHEN Session Medium LIKE 'paidsocial' THEN 'Social' WHEN Session Source LIKE 'google' OR Session Source LIKE 'bing' OR…