We look at a ton of YOY comparisons. The best way we have found is in the dataflow(SQL or Redshift) we have columns for "current year sales" and "py sales" then we create a beastmode like sum(cy sales)-sum(py sales) or for the % (sum(cy sales)-sum(py sales))/sum(py sales). That approach allows you to throw anything on the…
Thanks! Do you know if we can expect to apply PDP to Datafusion datasets in the future? We are considering nuking that dataset and creating a datafusion if not.