-
MAX of SUM in Beast Mode Windowing Functions
Hello! Our org just had our windowing functions for Beast Mode turned on, and we're hoping to utilize it to calculate our MAX messages per second. Below is the logic I've gotten so far, but it does not work unless the table has all of the fields in it. We want to display the value dynamically, so we need to stay within…
-
OFFSET function in a table view
Hey Dojo! I'm looking to create a table that will dynamically show change between the row and the row above it. We need the table to automatically update the formula when one of the rows is filtered out (which makes doing this in ETL impossible). My idea was to do this with an LAG function or an OFFSET function, but since…
-
SFTP Error
I'm trying to load a set of historical data that is batched out monthly in an SFTP server via CSV files. I can do some of the files but there are a handful of them that provide me some sort of the same error. "The CSV appears to be corrupt near record '683741' field '11 at position '2779.' Current raw data:" Different CSVs…
-
Re: Period over Period using stacked bars
I was looking to add an extra layer of granularity to my period over period chart. Basically I want to combine a Year over Year card, and a stacked bar so we can quickly see that the balance between the two components isn't changing. With this chart I'm just looking to see the quantities, and I'm not going to be digging…
