-
Window Function on Fixed Column Finding Aggregations of Previous Beast Mode
Hello, I was hoping to find a way to take the MAX, MIN, and AVG of a calculation based on a column in a beast mode calculation. For example, I am creating the "Average Performer" as something like the below query but I am getting an error thrown. AVG(AVG((SUM(COMPLETED) / SUM(EXPECTED))) FIXED (BY GROUP_1)) I was basing my…
-
How do I set up multiple case statement for required field?
I'm trying to create a case statement to replace an empty field with the word 'incomplete' when the field in the previous 'required' column has a 'yes' response. When it has a 'no' response, it should be left blank. Here is a snip of the dataset. This is what I've got so far, but I realize the 'if null' statement doesn't…
-
Is there a way to craft a variable to group by Month/Quarter/etc. and still display YoY data?
I'm currently trying to accomplish this, but it's not allowing me to select comparison data since the Beast Mode output isn't a date field.
-
Broken line chart and want to connect the dots
Hi - I have this beast mode that I am using in a bar line chart. However since there aren't values for each time interval the line is showing as dots. How do I get the line to connect? Here is the beast mode and I can't seem to get things connected without breaking syntax: CASE WHEN 'id'='LIABILITY' THEN SUM('value') END
-
Exclude current month from Card
Hello again, I am trying to create a beast mode that would update automatically, but exclude the current month. I know there is a filter for this but we want it to update automatically for our users
-
Is there a way to make a Summary display of a Beast Mode a color?
I have a beast mode calculation showing the percentage change that I am displaying as the Summary Number. Is there a way to color code the percentage where if it is positive, make the value green or if it is negative, then make it red?
-
Y/N Function
I have a month goal, how do i write a Beast mode that showcase if a month or date goal is met? Below is the code I am using to showcase the goals of each month
-
Month and Actual Goal
Hello all looking to make a case statement, I could be using the wrong one. I want to have a Beast mode that states when a specific month then it states what the goal is, picture below. Thank you in advance
-
Summary Color Display
I am displaying a Beast Mode calculation as the Summary number. The Beast Mode is the percentage change. Is there a way to color code the percentage where if it is positive, make the value green or if it is negative, then make it red?
-
Beast Mode: Syntax issues on filtering out a Sum Total
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. I can't add a filter on the card since the removed values need to be in another part on the chart. CASE SUM('values') - SUM(WHEN id='LIABILITY' THEN 'values') END
-
Beast mode to filter out certain ID field then sum the remaining IDs 'value'
Hi - I am trying to remove certain IDs from a column then sum their values but can't get the syntax correct. Here is what I've gotten to but doesn't work. Problem with adding a filter is the removed values need to be in another line on the chart. Case When sum('value') - (when ID='Liability' Then sum('value')) End or Case…
-
Adding Images to Table Card Using Beast Mode
Can someone help me with the formula to add a different image for each row in a table? I've been using the attached article. I've been able to get an image added, but the same image is in each row. I can't figure out how to get different images to populate in each row, like the sales rep image example in this article.
-
Include Data for a specific date range
Hello - newbie here - I need to know how to only include data that falls within my defined start and end dates columns. There are multiple flight dates, so I need to be able to bucket the daily delivery data within those defined dates. It just pulls in all of the data for each flight and I cannot seem to get it to work. I…
-
Beast Mode: How to aggregate a value for 1yr and remainder of the yr from a date?
Hi - I am trying to figure out how to aggregate values from a run date thru the end of the year as well as aggregating from that same date as_of_date for 1 year out. Essentially if the date is 5/31/23 it'll aggregate a value from that date through the end of the year (12/31/YY). Separately, from that same as of date…
-
Text box is not populated by Beast Mode
So, I have a beast mode that generates a text block with some basic information about a helpdesk ticket dataset. Its purpose is just to let the user know how recent the data they're seeing is. In short, it tells (1) when the ETL was last run, and (2) the most recent ticket ID and date. Simple enough, I'd think. If I add…
-
Why is my beastmode to bring in Salesforce Profile Photos not working?
I'm using the html code referenced in this Domo Article: Our salesforce rep profile photos are being brought in as a url starting with "https" into a user dataset. I'm just not understanding what is wrong with the beastmode that it's not bring up the photo when I place the beastmode as a column on a table: CONCAT('<img…
-
Issue with null data
I am using the below beast modes calculations for a chart. where I am trying to find the no of records received today and yesterday. Data appends itself in the dataset date wise. Eg: if yesterday 1 record received, today 2 records received. dataset will show 3 count for today. Beastmode: today: case WHEN SUM(CASE WHEN…
-
Make it so that beast modes based on variables are usable on custom app cards
When creating a custom app card, I wanted to use a beast mode that includes a variable on my custom card. The beast mode returned to the custom card will always return the value as if the variable was the default value, even if it has been changed on the page. It would be good if the value from the beast mode (based on the…
-
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'.
-
Reuse Beast Mode field in another calcuation
Requesting to allow Beast Mode field created in a card to be used in another calculation. This feature is currently available in the "Add Formula" function in Magic ETL but not for beast mode calculations done in Analyzer.
-
Beast mode to generate Batch Date?
Is there a Beast mode that can generate Batch dates? A colleague of mine has a dataset that updates monthly, but does not include a date column. The internal clients who view the report would now like to see a breakdown by date. Is there a way to use a beast mode, or some other tool, to create a batch date calculated…
-
Beast Mode as Chart Label
Hello! I am using the filled gauge chart and was wondering if you could use a beast mode for a label. I am wanting to show if the the target value has been met or not. So it will say either "On Track" and if it hasn't been met it says "Behind Target." I used a case statement to capture that in a beast mode, but don't know…
-
Add a condition on line plot to toggle between AVG and SUM conditions
Hi, I have a column in my data 'Volumes' and I am using that as Y-axis of line chart which is currently set to aggregate as SUM(Volumes). I have a problem with it where I want it to perform AVG(Volumes) when one condition is met and perform SUM rest of the times. I am trying to perform this logic using calculated field,…
-
Is there a way to dynamically select the nth row of a table?
I have a table that is part of a drill path. The table is filtered by a bar chart that has a category and numeric value (x). I want to select row (x) from the table after it has been filtered. Is there a way to make this part of the drill path?
-
Beast Mode To Find Cumulative Progress Towards a Goal
Hello, I am currently using a filled gauge and I need to create a beast mode that takes the number of days in a month(needs to account for all 12 months) / days total of the month and multiply it by the goal of the month, which will always be 3. Any help appreciated, I have not been able to get my head around what this may…
-
How to add hyperlink in the table
I have the data of different segments and want to represent it in a single dashboard. To make it user-friendly, I want to make an index table stating all the segments and I want that when I click on the name of that segment or the link (which can be created in beast mode) from the table, to navigate to that particular…
-
Unable to use "AND" filtering
I have a column named "response_value" which is to be used as a global filter in the dashboard. I would like to filter distinct users who have all of the selected values under column "response_value". Currently, it works like an OR condition and counts users who were part of any of the response_value selected
-
Pivot Table and Horizontal Calculations
Hello, Wondering if we can get some advice on how to program horizontal calculations in a pivot table. Please see below the current view of the Pivot Table and how we need to put in horizontal calcs.