-
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…
