3 Replies Latest reply on Jan 16, 2019 11:24 PM by Sean Martin

    Visualizing duplicates requiring multiple dimensions

    Sean Martin

      Hello experts,


      I'm attempting to work on a new visualization and hitting a wall as to how to proceed.  Hopefully someone here with more experience than I will have some insights to help.


      As a summary of what I'm trying to achieve:

      - I have data of when customers use our assets

      - In this data set, there are approximately 150 customers and approximately different 6,000 different assets across a 2 month period

      - I'd like to show only where an asset have been used more than once in a day


      To date, I haven't been able to find an effective way to calculate and visualize this.  The challenge seems to be showing number of uses by asset by customer by day - but only where the number of uses for a day is >= 2.


      Any help would be very appreciated.




      *Edited to include workbook.*

        • 1. Re: Visualizing duplicates requiring multiple dimensions
          pavan hm

          Hi Sean,


          This can be done. Pls attach the workbook with dummy data. I should be able to help you.

          • 2. Re: Visualizing duplicates requiring multiple dimensions
            Jim Dehner

            Hi Sean

            you can do this with LOD expressions - not clear on the question - are you interested in customers that use any asset or they need to use the same asset more than once in a day


            in any event start with and lod that looks at cutmers and day combinations - like {fixed [customer],[date]:countd(assets)}

            will count the unique assets used by customer by day - then just filter for >=2



            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

            • 3. Re: Visualizing duplicates requiring multiple dimensions
              Sean Martin

              Thanks for the responses.


              I've now attached a "safe" version of the workbook with relevant data anonymised and non-relevant data removed.  As you can see, I'm struggling to find a good way to visualise this.


              Ideally, I'm trying to show for a given day, the number of assets that have been played more than once in a day - and potentially how many times they were then played.  As an example, a chart showing the number of asset plays at a customer venue beyond one - per day - and then being able to drill down to each customer if needed.


              Thanks for the tip with LOD expressions.  I haven't had much experience (or luck) with them to date, but will have a shot using your tip as a starting point.


              Thanks again,