12 Comments

  • Graeme Carmichael
    Comment actions Permalink

    James

    Try this:

    HOW

    • Month\Year (Ticket Created)

    FILTER

    • Year (Ticket Created)  is the last XX years

    To count active users, you need to create a new custom metric. If you have not created a metric before, please see this article as you cannot just type the code into the editor.

    The code is:

    This will count users that have created a ticket where the user and a ticket has not been deleted.

     

     

    0
  • James Pitcher
    Comment actions Permalink

    Hi Graeme,

    Thanks for spending your time to reply.  I'm not actually looking for when tickets were created, but when the users themselves were created/active.  I basically want to see the trend in total active users in the system for each month, to see how our customer base is growing.

    0
  • Graeme Carmichael
    Comment actions Permalink

    James

    Then you need:

    HOW

    • Month\ Year (User Created)

    FILTER

    • Year (User Created) is the last XX years

    and a new custom metric to count users:

     

     

    0
  • Graeme Carmichael
    Comment actions Permalink

    James

    This will give you new users each month. Is that ok?

    0
  • Seodew10
    Comment actions Permalink

    Thank[url=http://ufa007.com][size=1px]ufabet[/size][/url]:d

    0
  • Teri Bayrock
    Comment actions Permalink

    Hey Graeme (and others!) 

    Similar to James, I'm looking to measure the total number of active users on a monthly basis. What's been suggested here will provide the number of new users created every month, not the sum of all end users.

    For example, I'm hoping to see a line chart of our overall userbase growing every month (so if we had 500 users in December 2018, and 2 new ones were created in January 2019, then the data point for January 2019 would be 502 and not 2)

    Is this possible?

    Thanks,
    Teri

    0
  • Graeme Carmichael
    Comment actions Permalink

    Teri

    So we already have a metric, #users,  to count new active users:

    We now need to sum this from the beginning of time:

    ...to give you the total active users at any point in time:

    # Users, the original metric shows the users created in month and the new metric, Count All Users, shows the total active users to date.

    Note that an active user may not have logged on to your help desk or raised any tickets.

     

     

    1
  • James Pitcher
    Comment actions Permalink

    Graeme, you ace'd it - thank you!

    0
  • jonk
    Comment actions Permalink

    Hi Graeme, more along this thread.  Am looking for similar to above but with a stacked bar chart each month by organization name.  The issue I see is that the runsum value for months where there are no new users in an organization show as 0 for that org even though it is a runsum.  The result is that the the stacked bar total is only correct for months where every org adds a new user.  I tried using INFULL but that didn't help.

    SELECT IFNULL ((SELECT RUNSUM(# End-Users) WITHOUT PARENT FILTER), 0)*1

    0
  • Graeme Carmichael
    Comment actions Permalink

    Jonk

    Unfortunately, this approach only works for reports with one attribute. Using both the date and organisation breaks that.

    If you are interested in specific organisations, you would have to create a metric for each one and include that in your report.

    For example, 

    Metric:Users In Company1

    SELECT IFNULL (( SELECT #users WHERE Organization = Company1),0)*1

    Metric:Total Users in Company1

    SELECT RUNSUM ( Users In Company1 ) WITHOUT PARENT FILTER

    0
  • James Pitcher
    Comment actions Permalink

    Hi Graeme,

    Hoping you can help me again with a similar request.  I am looking for a report of users that actively logged into Zendesk (to access Guide) month by month, e.g.  Each month, how many users logged into Zendesk Guide?

    0
  • Graeme Carmichael
    Comment actions Permalink

    James

    Unfortunately we do not have records of user log on activity. Only the user's last log on date. So it will not be possible to see how many users logged in to Zendesk Guide by month.

    0

Please sign in to leave a comment.

Powered by Zendesk