#6545 Show forum stats graph NEEDS ENSURE_INDEX

v1.0.1
closed
sf-4 (340)
General
2015-08-20
2013-08-09
Dave Brondsema
No

Let's show forum stats as a timeline graph (with supporting table below it). Show for the whole tool the # of posts per day. At longer time intervals, aggregate to a month. We've done some testing with mongodb aggregation queries [#6081] and with some index, it should be fast enough we think.

Page layout similar to SourceForge download stats, e.g. https://sourceforge.net/projects/openofficeorg.mirror/files/stats/timeline is what I'm thinking

Related

Tickets: #4906
Tickets: #6654

Discussion

  • Dave Brondsema
    Dave Brondsema
    2013-08-09

    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,3 +1,3 @@
    -Let's showing forum stats as a timeline graph (with supporting table below it).  Show for the whole tool the # of posts per day.  At longer time intervals, aggregate to a month.  We've done some testing with mongodb aggregation queries and it should be fast enough we think.
    +Let's show forum stats as a timeline graph (with supporting table below it).  Show for the whole tool the # of posts per day.  At longer time intervals, aggregate to a month.  We've done some testing with mongodb aggregation queries [#6081] and with some index, it should be fast enough we think.
    
     Page layout similar to SourceForge download stats, e.g. https://sourceforge.net/projects/openofficeorg.mirror/files/stats/timeline is what I'm thinking
    
    • Size: --> 4
     
  • Dave Brondsema
    Dave Brondsema
    2013-08-09

    • Milestone: forge-aug-23 --> forge-sep-06
     
  • Dave Brondsema
    Dave Brondsema
    2013-09-03

    • status: open --> in-progress
    • assigned_to: Dave Brondsema
     
  • Dave Brondsema
    Dave Brondsema
    2013-09-06

    • summary: Show forum stats graph --> Show forum stats graph NEEDS ENSURE_INDEX
     
  • Dave Brondsema
    Dave Brondsema
    2013-09-06

    • Milestone: forge-sep-06 --> forge-sep-20
     
  • Dave Brondsema
    Dave Brondsema
    2013-09-09

    • status: in-progress --> code-review
     
  • Dave Brondsema
    Dave Brondsema
    2013-09-09

    allura:db/6545, merciless:db/6545

     
    • QA: Tim Van Steenburgh
     
    • status: code-review --> closed