Facet aggregate: graph of number of climbing days in stats / historical development

[jschlatow]

It would be nice to have the number of climbing days calculated and shown in the stats view. This should be subject to filtering as well so that one can determine the climbing days within a given time frame or a particular area.

I could also imagine some more sophisticated evaluations:

• average number of climbing days per year
• average number of ascents per climbing day
• graphs which plot the number of climbing days by year and month

[scd]

nice idea. It's going to be a while before we get onto the profile page again. Lot's of ideas brewing for the profile page.

[brendanheywood]

Yeah I've had this idea too. I like what github does (as usual!):

https://github.com/brendanheywood

Also concentric bands of color for each day like

[brendanheywood]

See also #1696

[brendanheywood]

+1 via https://github.com/theCrag/website/issues/3457

[brendanheywood]

Fleshing this out I think there are a couple of very similar facet aggregates that we could show:

• given a node, show the count of ascents per time period (day, week, month, or year) (I'd also break this down by gear style)

/somecrag/ascents/aggregate/ascent-style-count/by/brendanheywood?period=week

• given a node, show the sum of the height of ascents per time period (day, week, month, or year) also broken down by gear style. The height could include estimates if missing (see https://github.com/theCrag/website/issues/3197#issuecomment-490932146)

/somecrag/ascents/aggregate/ascent-style-distance/by/brendanheywood?period=week

Depending on the time period we would display this differently. If the period is days I'd show it as a yearly calendar. If week or month then different calendar views. For a year it would be a linear timeline. Both of these should be the same template.

Both of them could also be swapped to show the breakdown by grade instead of gear style.

/somecrag/ascents/aggregate/ascent-grade-count/by/brendanheywood?period=week /somecrag/ascents/aggregate/ascent-grade-distance/by/brendanheywood?period=week

I originally thought a barchart for these but I think showing it as a gear donut / grade bubble like on the history aggregate is the better way.

• given an node, show the count of unique climber days per time period (day, week, month, or year). I think this one could have several numbers per time slot:

a) the first is the count of unique primary accounts who ticked b) the second is the count or other mentioned accounts, but excluding those who are already in a) c) the third is the count of other text names

/somecrag/ascents/aggregate/visits-style-count?period=week

This one I think is best as a stacked bar chart.

Some of these will be very computationally heavy so maybe support only or admin only.

[brendanheywood]

Also another duplicate https://github.com/theCrag/website/issues/1087