3 Replies Latest reply: Aug 3, 2012 9:42 AM by Jose Tos RSS

    Apply dimension restriction on a set analysis

      Hello

       

      I am trying to implement a dashboard showing users access statistics.

      More specifically, I created a graph

      - dimension : months of the year,

      - expression: number of users who connected more than 20 times.

       

      I have tried to implement it with this expression:

      Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID)

       

      The issue is that the dimension is applied to the UserID only, not to the session count.

      So in reallity my expression calculates the number of sessions irrespective of the months.

      If I put a filter on a specific month, then the value shown is correct. Without filter, the values are wrong.

       

      Anyone can help here to get the expression right?

       

      Thanks

      Greg

        • Re: Apply dimension restriction on a set analysis
          Jose Tos

          Do you have a Month and Year field in your calendar??

           

          This expression will make the count grouping by the field you choose, I´ve written MonthYear in the example

           

          aggr(Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID), MonthYear)

           

          Hope this helps

            • Re: Apply dimension restriction on a set analysis

              Hi José

               

              I do have a dimension called "YearMonth" in my calendar, and that's the one I use for my graph.

              When I try applying your recommandation, the outcome is exactly the same, count of UserID is split based on the dimension (month), but the count for session start for each user is over the whole period in my calendar, not split by month also.

              If I select one month only in the graph, then the session count will be restricted to that month only and the result displayed will be correct... but only one month is displayed, not the whole calendar :-(

               

              Any other idea?

              Regards

              Greg

                • Re: Apply dimension restriction on a set analysis
                  Jose Tos

                  I think you must to use filters in blank to discard that filters, then, when you select a month, month filter will be discarded so that must show you the result for all your periods

                   

                  Count({<UserID={"=Count([Session Start]) >20"} >}DISTINCT UserID)Count({<UserID={"=Count([Session Start])>20"},Month=, MonthYear=>} DISTINCT UserID)

                   

                  regards,

                  chema