Sorting date range by week with date....

[Hugh Gage]

Hi,

I just set up a query using date range 'week mon-sun dates) and set to sort in ascending order as I normally do with other date formats. 

When I ran the query it failed citing the following error. Please can you advise:

Query failed: 400 badRequest Sort key ga:yearisoweek_daterange is not a dimension or metric in this query.

[Clinton Deacon]

yearisoweek_daterange is not a valid dimension in our system. Perhaps you meant yearweekiso_daterange

Kind Regards

Clinton Deacon

Senior Application Developer

http://www.supermetrics.com

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/bab64c5c-733a-4dc9-b1a9-434c3a748293%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Hugh Gage]

This is a screen shot of my filter. The error message I put in the original post is what I got when I ran it.

[Clinton Deacon]

If you change the value manually in the SupermetricsQueries sheet from yearisoweek_daterange to yearweekiso_daterange, it should work

Kind Regards

Clinton Deacon

Senior Application Developer

http://www.supermetrics.com

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/0fe6632f-aa54-4841-8358-3674fa6baf83%40googlegroups.com.