Project

General

Profile

Actions

communication #109118

open

OSRT: Access Grafana Update

Added by c.kwan about 2 years ago. Updated almost 2 years ago.

Status:
New
Priority:
High
Assignee:
Category:
-
Target version:
-
Start date:
2022-03-28
Due date:
% Done:

0%

Estimated time:

Description

Hello,

I am working on a Community Downloads Report to add to the Product 360 Dashboard in Power BI. This report will be used by the PMs to understand the OpenSUSE downloads.

Currently, the OSRT: Access report aggregates the information by day, week and month. Would it be possible to additionally aggregate the information by fiscal year and fiscal quarter in the report? This will allow us to understand the unique count of UUID during each time period and analyze any trends.

I have included the dashboard link below. Please let me know if you have any questions.

Thank you,
Clarissa Kwan

Grafana Dashboard: https://metrics.opensuse.org/d/osrt_access/osrt-access?orgId=1&from=now%2Fy&to=now%2Fy&var-frequency=month&var-product=tumbleweed

Actions #1

Updated by witekbedyk about 2 years ago

Just to clarify on definitions.

FY 2022 started on Nov 1, 2021 and ends on Oct 31, 2022.
FQ1 2022 started on Nov 1, 2021 and ended on Jan 31, 2022.

Is that correct?

Actions #2

Updated by c.kwan about 2 years ago

Yes, that is correct.

Actions #3

Updated by witekbedyk about 2 years ago

Updated the aggregation script adding new time intervals.

https://github.com/openSUSE/openSUSE-release-tools/pull/2782

Actions #4

Updated by witekbedyk about 2 years ago

Added new variable values to the dashboard.

https://github.com/openSUSE/openSUSE-release-tools/pull/2787

Actions #5

Updated by ddemaio about 2 years ago

  • Tracker changed from action to communication
  • Project changed from openSUSE Release Process to openSUSE admin
  • Assignee set to witekbedyk
Actions #6

Updated by ddemaio about 2 years ago

  • Project changed from openSUSE admin to openSUSE Release Process
Actions #7

Updated by c.kwan about 2 years ago

Thank you!

Actions #8

Updated by witekbedyk almost 2 years ago

I have recovered old missing data from backup logs and added pattern for Leap 15.4.

Kudos for:

  • Lars Vogdt for pointing to the backup logs
  • Bernhard Wiedemann for making them available on metrics.o.o
Actions

Also available in: Atom PDF