Hi everyone, From some months ago I am having a doubt about one query I made. In this query [1] I get 1085 items and I would like to get the same but as a bar chart. Thus I have this second query [2]. However, I don't know why in the second query I get only 573 items... The number of items differ a lot, but practically both are the same.
What could be happening?
Thanks in advance for your time!
Regards, Iván
[1]: http://tinyurl.com/ydhnwcr5 [2]: http://tinyurl.com/ycx2eyoc
Hi Iván,
The results are the same, but the number the query gives is measuring different things.
In the first query, you get one line per publication - total 1085 results = 1085 *publications*
In the second query, you get one line per author per year - total 573 results = 573 *author/year pairs*.
Each line in the second query has a count of the publicationsfor that person in that year, eg Verónica Cristina Trujillo González has seven lines for different years, but a total of 14 papers (1x in 2010, 3x in 2011, 4x in 2012...).If you total up all the publications, you get 1085 across all author/years - the same as your initial query.
You can't easily see that total in the query results, but you can check it by exporting the table, dropping it into a spreadsheet, and summing that column.
Andrew.
On Wed, 6 Feb 2019 at 14:03, Iván Hernández Cazorla ivan@ivanhercaz.com wrote:
Hi everyone, From some months ago I am having a doubt about one query I made. In this query [1] I get 1085 items and I would like to get the same but as a bar chart. Thus I have this second query [2]. However, I don't know why in the second query I get only 573 items... The number of items differ a lot, but practically both are the same.
What could be happening?
Thanks in advance for your time!
Regards, Iván
[2]: http://tinyurl.com/ycx2eyoc
Iván Hernández Cazorla Historiador e interesado en las humanidades digitales Miembro de Wikimedia España https://ivanhercaz.com | https://keybase.io/ivanhercaz _______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
-- - Andrew Gray andrew@generalist.org.uk