search

tomayac / wikipedia-tools-for-google-spreadsheets

Wikipedia Tools for Google Spreadsheets — Install:
https://gsuite.google.com/marketplace/app/wikipedia_and_wikidata_tools/595109124715?pann=cwsdp&hl=en
Apache License 2.0
144 stars 32 forks source link

Create sum for WikiPageViews #5

Closed Sadads closed 8 years ago

Sadads commented 8 years ago

Hey Tomayac, one more request. So the current WikiPageViews function returns an array of results for each individual day within a range of dates, but there are a number of situations where program leaders and folks will want to do sums of groups of days. Is there a possibility to add a boolean, or variable option at the end of WikiPageviews, which allows different outputs-- one of them being a sum of the pageviews, and one being an array? I could think of others as well (mean daily, for example).

tomayac commented 8 years ago

This can be done natively, as in this example: =SUM(QUERY(WIKIPAGEVIEWS("en:Wikipedia"), "SELECT Col2"))

Sadads commented 8 years ago

Yeah, we figured something like that out for ourselves. However, doing sophisticated parsing of arrays within formulas, is a bit beyond the skill/knowledge of some of your reusers (I wonder if that can be either integrated into the documentation, if you don't want to build it in as a function).

Cheers,

Alex

On Tue, May 10, 2016 at 5:18 PM, Thomas Steiner notifications@github.com wrote:

This can be done natively, as in this example https://docs.google.com/spreadsheets/d/1V6QAmUghrShHZI9HO_Cj7w-68H8VLP3iatZ_MS2WYmc/edit?usp=sharing : =SUM(QUERY(WIKIPAGEVIEWS("en:Wikipedia"), "SELECT Col2"))

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/5#issuecomment-218294640

tomayac commented 8 years ago

Fair enough, I agree that this convenience feature could be supported. I reopen the Issue and will implement it as soon as I have some spare cycles.

Sadads commented 8 years ago

Thanks your awesome!

Cheers,

Alex

On Thu, May 12, 2016 at 9:00 AM, Thomas Steiner notifications@github.com wrote:

Fair enough, I agree that this convenience feature could be supported. I reopen the Issue and will implement it as soon as I have some spare cycles.

— You are receiving this because you authored the thread. Reply to this email directly or view it on GitHub https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/5#issuecomment-218749542

tomayac commented 8 years ago

@Sadads, this has finally been closed with https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/commit/a20bed77d4d282bdf8ca85c140b0b5dd82febe9d. The new version has just been deployed.