@Sgs @Cyndymediawiksim Can T374464 be a child of this?

In T371347#10134993, @DMburugu wrote:

@Sgs @Cyndymediawiksim Can T374464 be a child of this?

Sure. This task needs to wait for the community updates module to be enabled in at least one production wiki, so the relevant table is accessible from Superset.

Two dashboards were created as a result of this task :

• based on test wiki data : https://superset.wikimedia.org/superset/dashboard/552/
• based on test data : https://superset.wikimedia.org/superset/dashboard/550/?native_filters_key=a4VTdI2sxKFaz91-Fo5QVGCEMOdu1sWolo1sC0c7Y6Kd1lRtCduwXq0MwRcJ-TlT

In T371347#10192893, @Cyndymediawiksim wrote:

Two dashboards were created as a result of this task :

• based on test wiki data : https://superset.wikimedia.org/superset/dashboard/552/
• based on test data : https://superset.wikimedia.org/superset/dashboard/550/?native_filters_key=a4VTdI2sxKFaz91-Fo5QVGCEMOdu1sWolo1sC0c7Y6Kd1lRtCduwXq0MwRcJ-TlT

Both dashboards are present in supereset. Pinging @nettrom_WMF for checking if the dashboards have the needed info. Two notes

• changing filters often produce erorrs, e.g. changing Time to Last month or Last day instead of default Last quarter on dashboard/552 results in Unexpected error. However, it's outside the scope of this task.
• (super minor) the title SDS 2 Sprinthackular 2024 - Community Updates per-defines the specific part of any title on a dashboard. Since it's rather long, the specific part of the title (e.g. CTR per update) got hidden:
  

Both dashboards are present in supereset. Pinging @nettrom_WMF for checking if the dashboards have the needed info. Two notes

• changing filters often produce erorrs, e.g. changing Time to Last month or Last day instead of default Last quarter on dashboard/552 results in Unexpected error. However, it's outside the scope of this task.

Thanks @Etonkovidova for noticing this, the change in date filter causing errors seems to be a client-side timeout issue. The timeout settings in Superset might be too short for these queries. See superset FAQ docs for more information on this.

• (super minor) the title SDS 2 Sprinthackular 2024 - Community Updates per-defines the specific part of any title on a dashboard. Since it's rather long, the specific part of the title (e.g. CTR per update) got hidden:
  

We can make a quick change to abbreviate the dashboard title prefix. Can you suggest a preferred short version?

In T371347#10205723, @Cyndymediawiksim wrote:

Both dashboards are present in supereset. Pinging @nettrom_WMF for checking if the dashboards have the needed info. Two notes

• changing filters often produce erorrs, e.g. changing Time to Last month or Last day instead of default Last quarter on dashboard/552 results in Unexpected error. However, it's outside the scope of this task.

Thanks, @Cyndymediawiksim - yes, it's outside the scope. Btw, it's a rather common issue for superset. I've seen on other teams' dashboards too.

Thanks @Etonkovidova for noticing this, the change in date filter causing errors seems to be a client-side timeout issue. The timeout settings in Superset might be too short for these queries. See superset FAQ docs for more information on this.

• (super minor) the title SDS 2 Sprinthackular 2024 - Community Updates per-defines the specific part of any title on a dashboard. Since it's rather long, the specific part of the title (e.g. CTR per update) got hidden:
  

We can make a quick change to abbreviate the dashboard title prefix. Can you suggest a preferred short version?

Hmm... we may ask @KStoller-WMF and @nettrom_WMF for the titles naming.

Hmm... we may ask @KStoller-WMF and @nettrom_WMF for the titles naming.

I think shortening to Community Updates makes sense (remove SDS 2 Sprinthackular 2024 -).

Can we also remove (testwiki data) from the title, or will this dashboard really only ever be usable for testwiki?

@KStoller-WMF we were able to query the data produce in betawiki as seen in this superset dashboard: https://superset.wikimedia.org/superset/dashboard/552/