Derreck

How can this be changed to include prior year 12 months (24 months ago)?

@GrantSmith @jaeW_at_Onyx @ST_-Superman-_ Thank you for providing the clear detail! Worked perfectly! does anyone have any suggestions on building an LTM rolling turnover rate beastmode? I have window functions enabled in my instance. Thank you!

Hi @GrantSmith I don’t have any missing weeks (I have a separate date dataset joined). I am trying to calculate for each customer. Are you suggesting the beast mode below would be correct? Example of a rolling 4 day average (LAG(SUM(`OT Shipped`)) OVER (PARTITION BY `Customer` ORDER BY WEEK(`Date`,2)) +LAG(SUM(`OT…

@GrantSmith Thank you!

@GrantSmith Do yo have a sample beast mode for calculating a 13 week rolling average for on time delivery? Here's what I have currently. Output im trying to achieve is the following columns - Date, Customer, Rolling Avg. ( lag(sum(`OT Shipped`/ `Total Shipped`)) over( order by `Customer`,`Week Date Grouping`) + lag(sum(`OT…

@GrantSmith What if you would like to have Monday as the first day of the week?

@GrantSmith Can this same beast mode be utilized within a Formula Tile in ETL 2.0?

never mind! Found it! rank() over (order by sum(`amount`)desc)

@jaeW_at_Onyx is there a way define the order by to descending? Appears too default to ascending? thank you!

@GrantSmith , @jaeW_at_Onyx Whats interesting to me is the airtable cloud integration displays correctly in Domo when using Markdown enabled in Airtable. I linked two screenshots for reference. Also, If I copy the text from the Domo table card I see the following when I paste in Apple Notes: 1. Fighting with suppliers for…

@BrendanH , Thanks for the response! Yes, we would like the end result to like the example below: * 7/25 - There is a call with TrackVia to discuss their platform * 7/26 - CRM kick-off meeting to get all parties in the same room and form a solid game plan for CRM development and responsibilities. Notice the proper line…

To be honest, I'm not exactly sure on how to apply a color rule against it. Do you have a suggestion?

Thomas, Have a look. I bolded the small typo in the beast mode. the original beastmode had " vs. '. Hope this helps. CONCAT('<a style='color: , (CASE WHEN `Value` < 15 THEN '#f00' WHEN > 50 THEN '#00c200' ELSE '#ff0' END) ,">',`Value`),'</a>')