2 Replies Latest reply: Nov 19, 2015 5:42 AM by Nihal Cakir RSS

    Count users with at least one publication - improve expression

    Nihal Cakir



      I have a big dataset with 3,5 Mio Users and 50 Mio Publications.

      I am using the expression

      =Count({$<UserID = {"=Count(PublicationID) > 0"}>} UserID)

      to count the number of users having at least one publication. I already removed the distinct from the expression, but the calcualtion is still really slow.


      Does anyone have an idea if there is a better (less performance-consuming) way to write this expression?


      Many thanks in advance,


      Maybe I should add the following: when I use a straight table (chart) for the calculation, it takes long/crashes.

      When I use a simple textbox, it works fine.