-
Period Over Period Calculation Challenges
I am trying to calculate the difference between periods for a specific metric and am running into some trouble. (As you can see from the screenshot below, the Beast Mode calculation I am using doesn't seem to be working.) To generate the column totals, I am using this beast mode successfully for each desired date…
-
Ignore Row Context / Power BI 'ALL()' Equivalent?
I mocked up a simple example to illustrate what I'm trying to accomplish. The question is: how to create a beast mode which will ignore any filters and/or table row context applied to a column, in this case `Store`. The goal is: calculate Average Order Value for the entire dataset (Total Company), so individual Stores can…
-
Date Filter Card Will Not Toggle
Hello! This is my first time posting on the Dojo. I am trying to set up a 14-day and 30-day card filter for my org. The one used at the moment does not toggle. So if I select the 30-day card filter, it will stay at the 30-day filter if I deselect the check box or slide the slicer. It will only go back to default if I clear…
-
How can we download list of beast mode made on particular Dataset ?
Like I can see the list of all beast mode on a particular dataset on beast mode manager .But I want to download them also as per the particular dataset . Suggest me some way if there is any .
-
Creating a Link Field in Domo
Hi All, I was trying to have a hyperlink embedded inside a Domo Table/MegaTable and I used the following method. CONCAT('<a href="https://na132.salesforce.com/', `donation_link`, '" target="_blank">', 'Donation Link', '</a>') Now this is working perfectly on Domo but one major problem I'm facing is when I export the data,…
-
Help with beast mode formula - "case when" with date ranges
Hello! A little context about the use of this beast mode in the card: Looking at YOY data with same date ranges Date Ranges: 8/11-10/10 Here is the formula I have created: case when month(`date_purchased`) = 8 and DAYOFMONTH(`date_purchased`) >= 11 then 1 else case when month(`date_purchased`) = 10 and…
-
How to Deal with Multiple Date Fields
I have a perplexing issue I'm trying to solve. I have data coming from several different data sources (all parts of Zendesk), each of which each represent a different kind of user interaction. For example: Email, Chat, Phone Calls These are all related to a master "Tickets" table, so they can be joined based on a Ticket…
-
Any chance I can add in a percent change over various fields in a pivot table via window funciton?
I am doubtful that it is possible, but I'm holding out hope that somebody might have some insight. In excel I can take the values of two different cells per row to calculate a percent change, but in SQL I only know how to do this when it's isolated across a single dimension. Below is a screenshot of two pivot tables with…
-
Page Level Date Filter nulling when not available in every dataset
I have a dashboard with cards running on multiple datasets (5+). To make date selection easier for users I've created a beastmode titled exactly the same across all datasets to show Q#-YYYY. There are instances where a there will be records of that date in some datasets and not others, the issue here is that I assumed as…
-
Trying to hide past months for one value in a beastmode
I am trying to use our actuals to track past month/current value and our forecast to use future month value and I am having trouble writing the beat mode to do this. CASE WHEN YEAR(`Period Date`) <= YEAR(CURDATE()) AND MONTH(`Period Date`) <= MONTH(CURDATE()) THEN 'Hide Future Months' ELSE 'Show Future Months' END Here is…
-
Is there way to extract week of quarter from a date column?
The default week() function extracts the week number from the start of the year and runs 1 to 53 or 54. I need to show week number within the quarter, running 1 to 13 or 14 within each qtr. Is there a way to do this using beast mode or using the formula tile in Magic ETL ? Thanks!
-
Fiscal calendar - select like other date-related filters, bulk enable on cards, apply to beast modes
We want to use custom fiscal calendars in our subscriber instances, so our customers can have their fiscal calendars. However, a few limitations of the fiscal calendar in its current form will prevent this from being useful for our published content. We want users to be able to choose if they want to view a visualization…
-
Dynamic Segments
Looking to create a segment calculation that essentially becomes the leftover rows of what is filtered. So lets say you have 5 zones and someone filters the page on Zone 1. I want the other zones to show up for comparison. The filtered zone will be highlighted. This is a workaround attempt at highlighting page filtered…
-
How do beastmodes handle filter context?
Please can someone explain what happens under the hood when we slice beast modes (BMs) by dataset fields and/or when a filter is applied to BMs (categorical field filters/date filters) BMs using SUM() or COUNT( DISTINCT() ) when sliced or filtered don't behave as expected. (expectations being the issue). In one case, I had…
-
Filtering table -- cells can have multiple values
I have a dataset table with filters. Some cells have multiple values. Say I have a column called "Device." Row 1 can have "Desktop, mobile" and Row 2 can have "Desktop." I want to have a filter called "Desktop" that shows all rows containing any instance of "Desktop." When I do the beast mode formula: case when `Device`…
-
Calculated Fields - Pipedrive ID's
Hi, I am pulling in data from Pipedrive and need to use Calculated Fields to convert Pipedrive Field ID's into text. Is there a way that I can do this once instead of doing calculated fields for each metric?
-
group by and sorting by date
I have daily data (years of it) that will be grouped by category (columns summed by group), but also need it to happen within different date ranges. Last week, MTD, QTD, YTD etc. The only way I can think to do this is maybe in the ETL creating a new column with case statements for each category/date possibility, but this…
-
How to show a specific date with an aggregate (max)
Hey guys, So I'm creating a card that looks at the sales of our employees each day and then lists the day with the max sales. Our Data is structured by transaction, so I had to create a Magic ETL to Group the sales by date and employee in order to find the max by day. The problem I'm having is when I try and display the…
-
Domo beastmode and pivot question
Hello, I'm trying to automate a file to run calculation in DOMO on a card. In the attached I added a sample data and a pivot table to show what I'm trying to get to. I was able to get the pivot completed in DOMO, but the additional column Collection Total, I cannot figure out how to create a beast mode for this, I'm trying…
-
How to remove empty columns from a dataset?
I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no value. Can a query be written to remove all the columns with no values? I know I can write a script using Python/R but we don't have a scripting tile in our package.
-
How can I prevent a running backlog total beastmode from hitting zero?
I'm working on building a labor model for my department to track where our projected backlog will be over the next several weeks. One problem I'm running into is when the incoming backlog is less that what we're projected to process, the backlog goes into the negative instead of hitting zero which then throws off all…
-
Beast Mode for Getting the order status of the vehicles on order
I am trying to determine the status of the vehicle on order -Whether it is stock or Sold , whether it is part of the BAM campaign or not and the sold or stock date based on the following set of rules If the data column orderstatus has *SLD ,SLD or SOLD then the comment column is sold ; if the orderstatus column has STOCK…
-
Beast Mode Manager - Cards using this Beast Mode
I'm working on some consolidation and updates to some frequently used Beast Modes. On the Beast Mode Manager page, one of the formulas in question is used on 103 cards. But the summary only shows 20. Seems the list has a hard cap of 20. How do I see all cards using this formula? Is there a setting to show all somewhere? Or…
-
How to convert Milliseconds into Date
I have a data set with timestamp represented in milliseconds and I want to convert it into date . Data sample: "1656076776827" Expected after conversion: "24 June 2022 09:19:36" I looked at the beastmode and could not find anything that would help me to convert it, any suggestions?
-
% Change Columns in Pivot Table
Hi Dojo Community! My team is trying to create a card for a customer that allows them to select a range of years and/or months to compare (they will most likely view one month at a time), apply additional filters as needed, and drill into the table. The card should be structured like the screenshot below. There should be a…
-
Beast Mode Help Avg Order Value PoP
I'm trying to calculate the average order value and make a percentage to compare to it last year. Below is the beast mode, I've been trying to use. I have the Domo dimensions calendar hooked up to this flow. (SUM(`Current Gross Sales`) / COUNT(`Current Orders`) - SUM(`Last Year Gross Sales`) / COUNT(`Last Year Orders`)) /…
-
Duplicate data points for Weekly Reporting. I need the most recent day for weekly reporting.
Our subscription data is collected on multiple days throughout the week and creates a snapshot of that point in time. I want to see what that week's total was based on the most recent day. I don't mind removing the row with an earlier start date.