1 3 4 5 6 7 Previous Next 94 Replies Latest reply on Jan 14, 2019 3:50 PM by Yuriy Fal Go to original post
      • 90. Re: How to count distinct users on a running period
        Yuriy Fal

        Hi Ben,

         

        Could you please show (as a screenshot)

        just the Edit Table Calculation dialog of your

        LOOKUP([Rolling Unique Customer Count], -1)

        Table Calculation, especially the Nested calculations

        (there are the two of them I hope)?

         

        Besides, you may want to sync the Axes ;-)

         

        Yours,

        Yuri

        • 91. Re: How to count distinct users on a running period
          Ben wilson

          Thanks Yuriy.

           

          Here is what the table calc looks like by default for the LOOKUP series:

           

           

          With this setting, the chart looks like this (synced the axes). I've tried switching the table calculation to "compute using: Category Account IDs" like the original rolling unique count, but this just yields null values.

           

          • 92. Re: How to count distinct users on a running period
            Yuriy Fal

            Hi Ben,

             

            Thank you for reply.

            Could you please dig a bit further --

            under the Nested Calculations section?

             

            Each table calculation found there

            (in the dropdown list) has its' own

            Compute Using settings.

             

            It is outmost important to set them right

            for each "Inner" Table Calculation visible

            under the Nested Calculations section.

             

            I guess that for your specific Pills on a view

            the settings should be as follows:

             

            1) [In Window?] calculation should be set:

            Compute using --> Specific dimensions -->

            both Category Account IDs

            and Month of Transaction Date

            Re-starting every --> Category Account IDs.

             

            2) [Rolling Unique Customers] should be set:

            Compute using --> Specific dimensions -->

            Category Account IDs

             

            3) LOOKUP([Rolling Unique Customers], -1) should be set:

            Compute using --> Specific dimensions -->

            Month of Transaction Date

             

            Besides, the above setting should be applied

            to each and every Nested Table Calculation pill 

            on a view (on all shelves -- Viz and Filters).

             

            Yours,

            Yuri

            • 93. Re: How to count distinct users on a running period
              jeremiah.mercury

              Hello all — I've read through this thread and in addition had started my own thread before finding this one (Re: dynamically calculated DAU/rolling-MAU over time) but my issue is a rolling 28 day, so I'm not exactly sure how to implement the 7day fixes demonstrated on this thread even if I wanted to (which may cause performance issues because it is 4x the calculated fields than the 7day workarounds recommended on this thread). Has anyone figured out how to use LOD to support a rolling N COUNTD calculation? Thanks everyone!

              • 94. Re: How to count distinct users on a running period
                Yuriy Fal

                Hi Jeremiah,

                 

                I replied in your thread.

                 

                Yours,

                Yuri

                1 3 4 5 6 7 Previous Next