We used the generate rows icon to create the Annual_Transaction_Date as follows:
We created this URL based on the information we are pulling from our database. We had to create the Annual_Transaction_Date to reflect one year because our data was on days rather than years. After creating this URL the data we received was as follows:
Once we run the URLs created, we get an error message:
We are unsure as to how to correct this or where we made the mistake. Can someone help????
That worked well. We were able to move forward.
We came across another question. If we are trying to combine two zip codes that appear in the URL but have two different numbers in the _station how can I combine the two stations that pertain to the same zip code and get an average in the _value column?
These are few steps which you have to go through while downloading a file.