Skip to main content

    Idea Pipeline

    Filter by idea status

    Filter by product area

    6164 Ideas

    TMaier
    TMaierHelper ⭐️

    Period-over-period Formula Should Provide Detailed OutputsNew Idea

    This one is a true enhancement request - everything is working properly, but I think it could be better! Currently, when using a period-over-period formula in rules the most frequent use-case is to pull in a full range of timeseries data and apply the PoP formula in a followup Transform task. This adds the final PoP output to the task as a single formula field, which is fine….but…. What if I’d like to “show my work” - either for testing or to surface to end users somewhere? Well, I’d need to isolate the aggregated totals for each time period individually. Example below. ExamplePeriod-over-period calc for a field “Total Clicks” in a daily timeseries dataset. I’d like to see % change on the last 30 days (days 0-30) vs the previous 1 period (days 31-60).Total Clicks (days 0-30): 10Total Clicks (days 31-60): 15PoP Output: -50% In this example, the only data available in the output is the -50% figure. It would be AWESOME if the PoP formula actually output 3 fields here: one total for each of the aggregated “periods”, and the final % output. For multi-period deployments, the number of fields would go up to accommodate the additional periods. This could be an optional config, like a checkbox, so that people who dont want the raw data can elect not to deal with the extra fields. As it stands, those details are only available to me if I go through the extra steps of calculating them on my own - at which point I’m 90% of the way to doing my own PoP calculation using a plain formula anyway.