Here it is, Vitor:
[
{
"name": "default",
"label": "Spending by City, 2012",
"cuts": {
"time": "2012"
},
"drilldown": "gov-full-name",
"entity": "dataset",
"dimension": "dataset"
},
{
"name": "2011",
"label": "Spending by City, 2011",
"cuts": {
"time": "2011"
},
"drilldown": "gov-full-name",
"entity": "dataset",
"dimension": "dataset"
},
{
"name": "2010",
"label": "Spending by City, 2010",
"cuts": {
"time": "2010"
},
"drilldown": "gov-full-name",
"entity": "dataset",
"dimension": "dataset"
}
]c
From: openspending-bounces at lists.okfn.org
[mailto:openspending-bounces at lists.okfn.org] On Behalf Of Vitor Baptista
Sent: Thursday, July 25, 2013 1:40 PM
To: OpenSpending Discussion List
Subject: Re: [OpenSpending] Cuts and Programmatically Generated
Visualizations in OpenSpending?
Hi Marc,
Could you paste your "Views" content here?
Cheers,
Vítor Baptista
Developer | <http://vitorbaptista.com> http://vitorbaptista.com |
<http://www.linkedin.com/in/vitorbaptista> LinkedIn |
<http://twitter.com/vitorbaptista> @vitorbaptista
<http://okfn.org> The Open Knowledge Foundation
Empowering through Open Knowledge
<http://okfn.org/> http://okfn.org/ | <http://twitter.com/okfn> @okfn |
<https://www.facebook.com/OKFNetwork> OKF on Facebook |
<http://blog.okfn.org/> Blog | <http://okfn.org/about/newsletter/>
Newsletter
2013/7/25 Marc Joffe <marc at publicsectorcredit.org
<mailto:marc at publicsectorcredit.org> >
I loaded spending data for 260 California cities earlier and the it looks
pretty good (there are some errors due to duplicates on my side – but these
are minor). I have also had some luck with manually creating visualizations
for individual cities. I am not doing so well with JSON so maybe someone on
this list can help!
In the Views tab of the Manage function, I cannot figure out how to “cut”
the data by year. I tried using years and dates (e.g. 1/1/12), but no luck.
Can someone have a look at my data set at
http://openspending.org/pscs_ca_cities and tell me what I am doing wrong?
Also, I am not clear on whether or how I can manipulate the data set
programmatically so that I can generate one view for each city.
Marc
_______________________________________________
openspending mailing list
openspending at lists.okfn.org <mailto:openspending at lists.okfn.org>
http://lists.okfn.org/mailman/listinfo/openspending
Unsubscribe: http://lists.okfn.org/mailman/options/openspending
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending/attachments/20130725/4c9d20c9/attachment.html>