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

      Hi,

       

      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,

      Nigel



      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.