Date: Fri, 29 Mar 2024 10:31:53 +0000 (UTC) Message-ID: <1568714447.7843.1711708313115@ip-10-10-7-29.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7842_1532449192.1711708313113" ------=_Part_7842_1532449192.1711708313113 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Grouper could have a dashboard that shows the current state and = history of Grouper. This is an item for the future
Example is number of groups over time to show the adoption of your insta= nce
select = the_timestamp, (select count(1) from grouper_pit_groups gpg where gpg.start_time < (extract(epoch from the_timestamp) * 1000000) and gpg.name not like 'penn:community:student:course:%' and gpg.end_time is null or gpg.end_time > (extract(epoch from the_time= stamp) * 1000000)) as group_count from ( select current_timestamp as the_timestamp=20 union select TO_TIMESTAMP('2020-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2019-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2018-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2017-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2016-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2015-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2014-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2013-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2012-01-01','YYYY-MM-DD') union select TO_TIMESTAMP('2011-01-01','YYYY-MM-DD') ) as timestamps order by 1
Timestamp | Group count |
---|---|
the_timestamp | group_count |
1/1/2011 0:00 | 17228 |
1/1/2012 0:00 | 19923 |
1/1/2013 0:00 | 20652 |
1/1/2014 0:00 | 18105 |
1/1/2015 0:00 | 18359 |
1/1/2016 0:00 | 32055 |
1/1/2017 0:00 | 32629 |
1/1/2018 0:00 | 46546 |
1/1/2019 0:00 | 111503 |
1/1/2020 0:00 | 166846 |
10/2/2020 17:46 | 214476 |