Template talk:Property dashboard

Qualifier

@Jean-Frédéric: Is it possible to show qualifiers in the column or in the row? Pyb (talk) 16:43, 20 June 2019 (UTC)

@Pyb: I will look into this. Is this the same use-case as described on phab:T228405? Can you give an example on which items and properties/qualifiers you would need that? Jean-Fred (talk) 16:37, 15 October 2019 (UTC)

@Pyb: Support for qualifiers is live. Jean-Fred (talk) 18:41, 25 October 2019 (UTC)

New Parameter (for Property dashboard)

@Jean-Frédéric: Is it possible to add another parameter which allows to limit the statistics to statements that are only properly referenced? However, the parameter should have a form of exception mechanism for properties that typically do not require an external reference, e.g. images, official website, etc. Thanks Edwardleonar (talk) 08:32, 12 September 2019 (UTC)

@Edwardleonar: This should be possible in theory, but needs to be clarified.

• As per your second sentence, it would need to be configured on a per-column basis − we thus need to extend the syntax of the properties field.
• SPARQLing for statement that have at least one reference should be fairly straightforward ; however you say “properly referenced”: I imagine you mean excluding eg imported from Wikimedia project (P143) − is that correct? But in general, where would you draw the line between what’s “proper sourcing” and dumb sourcing? I don’t want to try (and fail) to make integraality too smart.
• If you could give an example SPARQL query, that would be great :)

Jean-Fred (talk) 16:43, 15 October 2019 (UTC)

Hi @Jean-Frédéric: Yes, statistics about statements with at least one reference, excluding "imported from Wikipedia XY". Here is some query code that might be useful, but it was written to do the exact opposite (returning the problematic items). I guess the challenge is to avoid server timeouts, i.e. the queries need to be properly broken down and the results assembled afterwards. Not really my cup of tea. --Beat Estermann (talk) 16:58, 15 October 2019 (UTC)

Tweaking the property dashboard to track problematic items from a data modelling point of view

Tracked in Phabricator
Task T224001

Hi @Jean-Frédéric:! - I'm planning to use the property dashboard to track problematic items from the point of view of data modelling - e.g. items describing at the same time museums (= organizations) and architectural structures (example). - Instead of displaying the statistics for a property, it would be way more useful to display a link to a query that, for each line of the table, outputs a list of the problematic items. Do you think it would be hard to implement this? --Beat Estermann (talk) 20:29, 12 September 2019 (UTC)

Hi @Beat Estermann:, This is a much-requested feature and is on the roadmap. It’s tracked at phab:T224001. Jean-Fred (talk) 15:22, 30 September 2019 (UTC)

@Beat Estermann: This is now live − the UI needs some tweaking but functionnally it should work :) Jean-Fred (talk) 18:42, 25 October 2019 (UTC)

By continent?

For situations like Wikidata:WikiProject Lighthouses/numbers/by country and property, is there a way to do a grouping directly by continent (i.e. without a grouping by country)?

Each items has country (P17) and values of country (P17) have continent (P30) (I'm aware that some country can end up being grouped several times). --- Jura 14:44, 28 February 2021 (UTC)

@Jura1: I think smth like P17/wdt:P30 would work − see eg User:Multichill/Windmill sandbox for a similar trick. Jean-Fred (talk) 20:40, 24 March 2021 (UTC)

• Indeed: Wikidata:WikiProject Lighthouses/numbers/by continent and property. Thanks. Should have thought of that. --- Jura 10:38, 12 April 2021 (UTC)

UNION queries

I have a SPARQL query that has UNION in it but I am unable to figure out how to get the query to work with the property dashboard. I'm fairly new to SPARQL, apologies if I'm missing something obvious. My query is below. Thank you. --Nashona (talk) 22:48, 12 March 2021 (UTC)

SELECT ?Northwestern_University ?Northwestern_UniversityLabel WHERE {
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
 { ?Northwestern_University wdt:P69 wd:Q309350. }
 UNION
 { ?Northwestern_University wdt:P69 wd:Q6806876. }
}

Try it!

That interests me too Palotabarát (talk) 19:36, 16 May 2021 (UTC)

Grouping by year

Tracked in Phabricator
Task T236590

I've been looking into how I can do grouping by year. In particular I would like to group by the year part of publication date (P577). I haven't figured out a way of doing this and just wanted to check if it is at all possible? /Lokal_Profil 21:51, 11 April 2021 (UTC)

That would be phab:T236590. Not possible at the moment though I’m afraid :-( Jean-Fred (talk) 10:14, 12 April 2021 (UTC)

Maybe you could compute the applicable year item (e.g. 2021 (Q49628)) and then group by that. --- Jura 10:35, 12 April 2021 (UTC)

Oh, probably not. Good idea for TV series. --- Jura 10:40, 12 April 2021 (UTC)

Thanks for the task, should have checked Phabricator first ;) /Lokal_Profil 08:38, 13 April 2021 (UTC)

|properties=P553/Q17459/P670 not working

Just a minor thing: |properties=P553/Q17459/P670 mentioned in the template's documentation doesn't seem to work, or, at least, I didn't get a similar to work ("P241/Q172771/P580" at [1]).

Somehow it seems to work when the main property (P553) is the property used for grouping ("P241/P580" at [2]). This solves it for my main usecase.

Still, e.g. P410/Q24038912/P580 [3] could be interesting (empty except for the incorrect row total). P241/P580 in the same should include a qid, but I skipped that as it's generally the one always present.

|properties=P553/P67 seems ok.

BTW, still a great tool. I should use it more often. --- Jura 06:39, 21 August 2021 (UTC)

Bigger Dashboards can't be updated anymore

Tracked in Phabricator
Task T302314

The Update of bigger dashboards like on Wikidata:WikiProject Nonprofit Organizations ends in on an error page "502 Bad Gateway (nginx/1.14.2)". Are they just too big, or is there a server problem? It worked in the past (last on 5th of Febuary). Best Newt713 (talk) 17:02, 22 February 2022 (UTC)

@Newt713: Is that the same as phab:T302314? Jean-Fred (talk) 17:42, 22 February 2022 (UTC)

Yes, that seems to be a question of a colleague. --Newt713 (talk) 18:46, 22 February 2022 (UTC)

The most likely explanation would be that the dashboard configuration was changed between Feb 5th and now ; but according to the page history, there’s no edits by the bot ever? Jean-Fred (talk) 17:44, 22 February 2022 (UTC)

Sorry, yes the example is only a copy of an instance on my userpage. But I get the same error occures on the example of sum of all paintings which is used as an example on toolforge. --Newt713 (talk) 18:46, 22 February 2022 (UTC)