-
SQL/Beastmode query for copying in values from another column
Hello, I have a dataset with lead sources from two different places, and I need to splice in the lead source from another column into the main column (Source - Mapped) only when criteria is met. I don't want to fully replace the data in the 'Source - Mapped' column because it has values that are not present in other…
-
Setting up a rolling sum based on date
Hello, We are trying to set up a beast mode or ETL Formula that will be able to calculate a rolling average of leads based on the last 30 days and the last 90 days. Ideally we would want to be able to compare the average number of leads for the last 30 days to their rolling 90 day average to see if the client's lead…
-
Beast mode 'Case when' for if a date exists
Hello! I am trying to write a beast mode that counts a row of data if a date is present. The first row of my beast mode is working, but I am having issues with the second row. Basically, if a move-in date is present (or is not null), I want to count that row in this calculation. I am new to writing beast modes so I am not…
-
Filter Cards Not Showing All Data
Hello, I have been trying to create dropdown filter cards to get around the fact that you can't organize the filter views on a dashboard after they have been created. I have two cards that allow the user to select the company/location of the data that they want to see. However, the card is not displaying all locations that…
