Beast mode case change based on whether or not a filter is in use
Hey all, Is there a way for me to use a beast mode to calculate a COUNT when a filter is not in use but to use a COUNT(DISTINCT) when a specific filter is in use or when a filter is applied on a dashboard around a specific field?
Effect of DataSet View Calculated Columns on Performance
I want confirmation that if I shift over a bunch of dataset view calculated columns to run in the dataflow instead of on the dataset view that I can potentially boost the performance of my dashboards. Currently, the dashboards run okay, but filtering takes a while. The dashboards are heavily leveraging COUNT(DISTINCT()),…
Period over Period Visual, YTD, 2 Day Delay with Current Date Data
Hi all, I'm leveraging the period over period charts and comparing the year to date progress with the progress from a year ago. Unfortunately, there's a two day delay in when the data comes in, and the historical period data isn't reacting to that. Is there a way to address that while still using the period over period…
Count Distinct with Fixed?
Do the fixed functions actually work with Count Distinct? I'm trying to leverage them to ignore some filters, but they're not producing the right results (always significantly higher). The example below does not include the filter bit since I can't even get the base of the function to work correctly. The window function I…
Is copying action nodes from one dataset to another possible yet?
This idea was mentioned towards the bottom of this thread by @MattGo and then @StevenC mentioned that it was a good idea back in 2017. Would save us a lot of time and add a lot of value.
Fixed Functions for Identifying the First and Last Connections for an Entity
Hi all. I built the following beast mode to identify the first and last connection for an entity. It validates and works when I lay out the connection ID and the beast mode in a basic table, but it doesn't really work with any other visuals (I get error messages), and when I tried to use this to build a net new column in…
Beast Mode Case Excluding Certain Strings
I'm trying to build a beast mode that outputs a value when one string of text is found and another string is NOT found. How do you do that in Beast mode? See example of what I'm trying to do down below. I included that minus in front of the semi to indicate that I do not want that string of text to be included. CASE WHEN…