Data Studio
2.1K members online now
2.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

URGENT ISO week number not recognized in report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

I'm struggling a bit with entering the format of a week number. I get the error message below.

My week # column is formatted as "Week 12". I have also tries many variations (week12, w12, 12), including returning a =weeknum() result but I keep getting the same error message.

Any help?

Thanks!
Screen Shot 2017-02-13 at 21.53.31.png

 

URGENT ISO week number not recognized in report

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Hi @Paul C,

 

I had this same error, however the date did work correctly in my report, have you checked to see if it still functions as expected regardless of this error message?

 

Ben

URGENT ISO week number not recognized in report

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

The same problem...

URGENT ISO week number not recognized in report

[ Edited ]
Follower ✭ ✭ ☆
# 4
Follower ✭ ✭ ☆

Try 201708 format


Paul C wrote:

Hi,

I'm struggling a bit with entering the format of a week number. I get the error message below.

My week # column is formatted as "Week 12". I have also tries many variations (week12, w12, 12), including returning a =weeknum() result but I keep getting the same error message.

Any help?

Thanks!
Screen Shot 2017-02-13 at 21.53.31.png

 



(example is this week) and see if that works...

URGENT ISO week number not recognized in report

Follower ✭ ✭ ☆
# 5
Follower ✭ ✭ ☆

Sorry - that did not work

 

Format that works for me is 201708

the example above is for this week.

URGENT ISO week number not recognized in report

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Format 201708 doesn't work as well.

Only if you take the full date and make it Week. But you know it will be difference in data because you can take one user several time a week day by day and take the same visitor only ones if use week))