Domo - calculate email campaign Open Rate w Windowed Functions скачать в хорошем качестве

Domo - calculate email campaign Open Rate w Windowed Functions

How to do cumulative #analytics by month in #Domo. Avoid aggregating data in ETL and instead, use more flexible #BeastModes. ##### CONSULTING SERVICES #### I provide consulting services through my company Onyx Reporting, reach out to me at jae@onyxreporting.com, or through my website, onyxreporting.com. help you implement or optimize existing data pipelines and dashboards. provide remote and onsite training augment your implementation team as part of a long-term engagement. ##### Original #DomoDojo post ##### https://dojo.domo.com/t5/Beast-Mode-E... #### TLDR Solution ##### Grand Total over the entire dataset sum(sum(Opens)) over() Subtotal resets every month sum(sum(Opens)) over(partition by month(date)) Running total sum(sum(opens)) over( oder by date) Running total per month sum(sum(opens)) over (partition by month(date) order by date) STICK IT ALL TOGETHER: Open Rate ratio sum(sum(`Opens`)) over (Partition by month(`Date`) ORDER BY `Date`) / sum(sum(`Sent`)) over (partition by MONTH(`Date`) order by `Date`)