Create running total not associated with timescale

PrevContributor
PrevContributor
in Modeling

We are looking for a way to assign decile values to transactions where the order of a measure in a module determines its ranking.  We cannot use the RANK() function (without a subset workaround) as the number of transactions exceeds 1M.  The CUMULATE function only applies on a timescale. Has anyone found a way to do this?  For example, a cumulative percentage or a pareto calculation?

Tagged:

Best Answer

  • Mark_W_Shemaria
    Mark_W_Shemaria
    Answer ✓
    [quote=Mitch Max]We are looking for a way to assign decile values to transactions where the order of a measure in a module determines its ranking.  We cannot use the RANK() function (without a subset workaround) as the number of transactions exceeds 1M.  The CUMULATE function only applies on a timescale.

    Has anyone found a way to do this?  For example, a cumulative percentage or a pareto calculation?[/quote]

    Transactions are grouped in 15 minute increments in order to achieve level of precision of the measure.

Categories