Forum Discussion

cblown's avatar
cblown
Boss
14 years ago

Ideas Statistics

Hi All   We are exploring options relating to the Lithium Ideas Exchange to create a custom component that displays   Number of ideas submitted Number of votes submitted Number of comment...
Views
Sign in to react to this post
cblown's avatar
cblown
Boss
14 years ago

After reading the Metrics List it looks like we can fetch the following:

 

Net Ideas - The number of ideas posted to idea exchanges (Ideas), minus the ideas that have been deleted (Ideas Deleted).

Net Ideas Comments - The number of ideas added to idea exchanges (Ideas Comments), minus those that have been deleted (Ideas  Comments Deleted).

 

2 down, 2 to go..

 

Can't see any reference to "Ideas statuses" and "Ideas Votes" though.. any ideas?

 

Sign in to react to this post
  • cblown's avatar
    cblown
    Boss
    14 years ago

    We are still looking for help with this issue, here is what we have so far: 

     

    • Number of ideas submitted    -- Using metrics Net Ideas 

    • Number of kudo submitted    --  Using REST api -  /boards/id/<id>/kudos/count we can fetch total kudos for each Ideas board and tally.

    • Number of comments posted  -- Using metrics Net Ideas Comments 

    • Number of ideas implemented -- No solution found ( we can't see anything in the metrics? )

       

    We've looked at the REST call

     

     

    /board/id/<id>/threads/for/message_statuses/id/<implemented> .. /top/count  .. /recent/count  ../popular/count  

     

    But we are after a count for ALL "Implemented" Ideas to date.

     

     

    Sign in to react to this post
    • BrodieJpk's avatar
      BrodieJpk
      Guide
      9 years ago

      This would be super helpful for our purposes too.

       

      Please forgive the ineptitude but in creating these calls, where it's like HTML code, as front-end users are we able to enter these somewhere to create reports? Or do we need access in the back-end?

       

      It would be really convenient for more detailed reports to come out of Ideas Exchange, including regularity of tags and labels, a status tracker to identify how long ideas have stayed in a status for, and how to measure individual ideas as well as figures taking into account how many ideas are moved and merged into others. 

       

      Would be super handy eh @ClaudiaS??

      Sign in to react to this post
      • ClaudiusH's avatar
        ClaudiusH
        Khoros Alumni (Retired)
        9 years ago
        To create UI components showing these metrics you would need a bit more than just plain HTML. You would create a custom component in the Freemarker markup language.
        Also keep in mind that since this question was originally posted the new Community API v2 with the LIQL query language was introduced which allows to form queries for all of these metrics.

        Regarding your ask for more detailed reporting:
        I assume you've already looked at the Ideas report within LSI which gives a high level overview into idea submission and commenting stats. Also when in LSI you apply a Topic ID filter for an individual idea you can get a history of posting and kudoing activity as a graph.
        We currently don't have a status tracker, but the current default ideas UI gives a breakdown of number of ideas in each status.

        I found your request for "tags and label regularity" an interesting one: What insight would you get out of that and what action would that lead to?
        Sign in to react to this post
    • mdfw's avatar
      mdfw
      Genius
      5 years ago

      Hi cblown ,

      I'm resurrecting an old thread but wondered if you were ever able to grab " Number of ideas implemented ". I'm trying to filter by date as well. I'd love anything that says "filter by status changed between date1 and date2" but I'm not seeing that either. Wondered if you had any ideas based on this old issue?

      Thanks!

      Sign in to react to this post