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

Adding constant values under 'Create new field'

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi Team,

 

We have Fiscal Year goals(which will remain same throughout year). Is there a way we can create a new field in data source - which takes constant values. I am not sure what is the formula to add constant value in data source. My data source is GA. Once I have this constant goal field, I can then easily calculate % goal achieved for various metrics like visits, visitors, conversion etc.

 

Could you please help.

 

Thanks & Regards,

Khushalie Nagpal

Re: Adding constant values under 'Create new field'

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I understand it's very dirty way but how about using case when statement with Date?

 

Adding constant values under 'Create new field'

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

How would you go about using a CASE statement with date? I also have a fiscal year that's non calendar, and I've essentially made all my charts calendar year since I haven't been able to figure out how to easily create the fiscal year dimension. 

Adding constant values under 'Create new field'

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I have the same doubt. I think it would be useful to have a way to create a constant that never changes.