unable to generate correct 'long' format from csv

When using a query builder to generate a url with csv output (selecting series on x axis and lastNObservations =1), the ouput generated is incorrect. Years are listed under the unit of measure and each country is a seperate column (see attached). Ideally the output would conform with tidy data standards (each variable forms a column and each observation a row: http://www.stat.wvu.edu/~jharner/courses/stat623/docs/tidy-dataJSS.pdf ). In addition, when selecting lastNoObservations, it would be highly desirible if no missing observations were returned (since removing missing cases is the objective of quering most recent values). Is there someway for me to specify this structure in the query builder? Thanks Each type of observational unit forms a table



    Please provide the query URL that you built. Thanks.
    Posted by Hidden Tue, 22 Aug 2017 14:16:33 GMT

You're not signed in. Please sign-in to report an issue or post a comment.