Page MenuHomePhabricator

📈Create chart showing the amount of total items/properties on Platform Summary Dashboard
Closed, ResolvedPublic

Description

We want to create a chart in the Google Cloud Console "Platform Summary" dashboard for:

  • total count of items over all Wikibases we host
  • total count of properties over all Wikibases we host

(total as aggregrations across the whole platform)

useful links:

Possible direction to work in:

  • We think this could be done by adding content to the public wiki api we're using for the discovery feature.
  • We could add additional WikiStats fields for these entities
  • These wiki stats fields could be populated by another api call

A/C:

  • 2 charts exist for both staging and production cluster
  • Need to be able to analyze trends over time, with at least a 2 month ongoing history
  • Charts are shown in the Platform Summary dashboard

Event Timeline

Evelien_WMDE set the point value for this task to 8.
Evelien_WMDE renamed this task from Create dashboard with charts showing the amount of total items/properties to Create chart showing the amount of total items/properties on Platform Summary Dashboard.Sep 8 2022, 2:12 PM
Evelien_WMDE updated the task description. (Show Details)

After inspecting this we believe that there is a necessity for a common api that returns wiki metrics for use here as well as in T324099 and whatever "discovery platform we build"

Tarrow removed the point value 8 for this task.Aug 3 2023, 1:10 PM
Tarrow added a subscriber: Evelien_WMDE.

@Evelien_WMDE We talked about if we should revisit the possibility for public readability of these graphs

@dang Hey! We noticed you licked this cookie and so wanted to flag up that we've stuck the ticket about trying out SuperSet (T358230) ahead of this ticket. We could imagine that the outcome of that would drive the work on this ticket or T343719.

We think this should involve something like the following steps:

  • count of pages in the item namespace using an API call to each wikibase
  • count of pages in the property namespace using an API call to each wikibase
  • save these into the WikiStats object for each wiki
  • export these to google managed prometheus for we end up with a nice timeseries graph

We're going to ship these api changes and then will move on to build the dashboard from there.

Fring subscribed.

While metrics are now being emitted, we will also need to update the Dashboard itself to display the metric, so I am moving this back to To Do.

Tarrow moved this task from To do to Doing on the Wikibase Cloud (Kanban Board Q2 2024) board.
Tarrow added a subscriber: dang.
Anton.Kokh renamed this task from Create chart showing the amount of total items/properties on Platform Summary Dashboard to 📈Create chart showing the amount of total items/properties on Platform Summary Dashboard.May 30 2024, 1:56 PM

Metrics are now being created and tracked.

https://console.cloud.google.com/monitoring/dashboards/builder/ad392594-80d4-4fde-9de7-94b2f03144f7;duration=P7D?project=wikibase-cloud is a proposed view for seeing these metrics.

If @Anton.Kokh is happy with this we should roll this one final change to production + staging and delete this copy of the dashboard

Tarrow moved this task from Done to To do on the Wikibase Cloud (Kanban Board Q2 2024) board.

Please re-organize data between charts in the following way:

  • rename users chart to users & edits
  • rename edits & pages chart to pages, items & properties
  • move the Total non-deleted edits metric from pages, items & properties to users & edits
    • in Y-axis assignment for the chart users & edits chart, user-related metrics should be on one side (for example, left) and edit-related metrics on another side (for example, right)
    • in Y-axis assignment for the pages, items & properties chart make sure that pages and items are on one side, and properties are on the other

Clarification: to update *Y-axis assignment* on a chart, go to Edit widget (upper-right corner), on the right expand Y-assignment section, specify which metrics belong to the left and which to the right.

{F54901296}

Make sure that all charts still show last month. For some reason on the version that Tom provided the URL to it only shows last week.

Also please rename 'editors' to 'users':

  • in the Total widgets above the charts
  • in the legend

This is the terminology used in other products.

Fring changed the task status from Open to Stalled.Jun 3 2024, 11:47 AM
Fring changed the task status from Stalled to Open.Jun 5 2024, 9:48 AM
Fring moved this task from Doing to In Review on the Wikibase Cloud (Kanban Board Q2 2024) board.