-
Calculating 7-Day Moving Average (Beastmode)
Hi I want to have a rolling 7 day average revenue for every day. Ideally, I would want the average revenue for 7 days previously for every day.
-
Last 30 days Workbench / SQL
Hi Domo friends, I want to query data via workbench but the backend table I'm pulling from is unnecessarily big. I want to limit the date from to the last 30 days from the current day and have it replaced every day. My inclination is something like: `select * from 'data_source' where 'day' = {!lastvalue:day!} - 30 but I'm…
-
Using the Limit function for a beastmode
Hello, I'm trying a little work around to get a top 10 list for a domo card based on revenue. To do this, I was planning on organizing each company by most revenue and doing a beast mode to limit the companies by 10. I'm not sure if this is possible, but I see that "limit" is a highlighted function for the beastmode -…
-
30 day running date alert
Hello, I'm trying to create a date range that will be continual, comparing today to 30 days ago. I have a feeling it's somewhere within creating a calculated field, but I don't know what the formula would be. My idea would be to have a specfic filter that would include date(today, today - 30days) but the actual process is…
