[Wikidata-bugs] [Maniphest] [Created] T150515: Graph view axes always begin at 0 when both coordinates are numeric

[WikidataFacts]

WikidataFacts created this task. WikidataFacts added projects: Wikidata, Wikidata-Query-Service. Herald added a subscriber: Aklapper. Herald added a project: Discovery.

TASK DESCRIPTION

Example query:

#defaultView:LineChart
SELECT ?year (COUNT(?person) AS ?count) WHERE {
  ?person wdt:P31 wd:Q5;
          p:P570/psv:P570 [
            wikibase:timeValue ?date;
            wikibase:timePrecision ?precision
          ].
  FILTER("1900-12-31"^^xsd:dateTime < ?date && ?date < "1910-00-00"^^xsd:dateTime).
  FILTER(?precision >= 9).
  BIND(YEAR(?date) AS ?year).
}
GROUP BY ?year
ORDER BY ?year

Link

Both axes (year and count) are numeric, which seems to be a corner case (used to summarize everything into one result, too) – in this case, both axes begin with 0, rather than a more appropriate value such as the lowest actually occurring value.

Workaround, found in the example queries: turn the X axis into a string with (STR(?year) AS ?year_).

TASK DETAIL

https://phabricator.wikimedia.org/T150515

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: WikidataFacts
Cc: Jonas, Aklapper, WikidataFacts, EBjune, mschwarzer, Avner, debt, Gehel, D3r1ck01, FloNight, Xmlizer, Izno, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Deskana, Manybubbles, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs