[openspending-dev] Returning additional measures in aggregate API

Mon Oct 8 09:43:43 UTC 2012

Ok, thanks. But it would be a nice feature to be able to add multiple
measures.

BTW: here is our visualization of the Norwegian National Budget, posted
online 30 minutes after the ministry published their super-messy
Excel-file:  http://politisk.tv2.no/spesial/statsbudsjettet/

Anders

2012/10/8 Friedrich Lindenberg <friedrich.lindenberg at okfn.org>

> Hey Anders,
>
> you're right, I didn't consider this yesterday! You can add
> measure=amount_last_year to the API call, but it doesn't yet support
> multiple values. I guess making each year into its own entry and doing
> a drilldown on that is going to be the easiest way of getting out all
> the info with one call!
>
> Cheers,
>
>  - Friedrich
>
> On Sun, Oct 7, 2012 at 5:56 PM, Anders Eriksen
> <anders.grimsrud.eriksen at gmail.com> wrote:
> > Hi.
> >
> > I am trying to add some additional fields/measuers to my data in order to
> > display more information in bubbletree tooltips (e.g. how has this amount
> > changed since last year etc).
> >
> > I have added a column named "amount_last_year" and added a corresponding
> > measure for my dataset.
> >
> > Loading of the dataset works fine, but when I access the data through the
> > aggregate API none of the additional measures are displayed, only the
> amount
> > measure.
> >
> > API-call:
> >
> http://openspending.org/api/2/aggregate?dataset=tester_nor2&drilldown=program_category%7Cdep&cut=year%3A2011
> >
> >
> > On the About tab in the meta information on Open Spending, the
> > "amount_last_year" measure is listed.
> >
> > Is there something special I would have to consider to get these
> additional
> > measures returned by the aggregate API?
> >
> > Best regards,
> >
> > Anders Eriksen
> > Newsroom developer
> > TV 2 Norway, News dept.
> >
> > _______________________________________________
> > openspending-dev mailing list
> > openspending-dev at lists.okfn.org
> > http://lists.okfn.org/mailman/listinfo/openspending-dev
> >
>
>
>
> --
> Friedrich Lindenberg <friedrich.lindenberg at okfn.org>
>
> OpenSpending - http://openspending.org
> OKFN Labs - http://okfnlabs.org
>
> Twitter: @pudo
> Web: http://pudo.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20121008/82855293/attachment.html>