ganncamp
(G Ann Campbell)
February 9, 2022, 7:40pm
1
I’ve been looking at some of the built-in reports, and I initially found the Trust Level growth startling:
On closer inspection, it looks like the query results aren’t properly ordered before they’re fed into the graph. I don’t know how else to explain seeing this sequence
2021-12-05
2021-12-26
2022-01-16
2021-12-10
2 Likes
dax
(Daniela)
February 9, 2022, 9:19pm
3
Thank for the report, I can confirm that the order in which the data is presented is incorrect, we will take a look.
2 Likes
Is there a way to run a report that shows total user growth (trust level 0) over a set period of time? I see the trust report, but it doesn’t include level 0. Is that something the data explorer can help with?
ganncamp
(G Ann Campbell)
May 5, 2022, 1:38pm
8
Following up on this, the default time range looks well ordered:
It looks like it’s when days get collapsed to weeks that things get weird:
ganncamp
(G Ann Campbell)
November 15, 2022, 6:20pm
9
Any progress? I have C-levels asking for metrics & I’d like to use this…
1 Like
Good news.
There’s a fix on the cards:
discourse:main
← discourse:fix-trust-level-growth-report
opened 04:47AM - 16 Nov 22 UTC
When the Trust Level Growth report in the admin dashboard has lots of data ( > 6… months of activity), the dates weren't ordered properly and this resulted in broken data in the chart and CSV export. Explicitly ordering by date fixes the issue.
Before
<img width="1246" alt="image" src="https://user-images.githubusercontent.com/368961/202085874-e48bf783-aa6b-406c-a903-93b23416ca8f.png">
After
<img width="1258" alt="image" src="https://user-images.githubusercontent.com/368961/202085914-be106a9c-c3eb-440d-a821-3fbde5ef0f66.png">
This PR does not include a test because the bug relies on lots of data and it would be very time-consuming to write a test that generates all that data, and the resulting test would probably be slow on every run.
It’s not merged quite yet, but hopefully shouldn’t be too long.
EDIT merged now!
4 Likes
sam
(Sam Saffron)
Closed
November 25, 2022, 4:38am
14
This topic was automatically closed after 7 days. New replies are no longer allowed.