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

YTD, MTD, WTD calculation

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi guys,

 

Has anyone figured out how to do year-to-date, month to date, week to date calculations with data studio?

 

Cheers,

Hristo

YTD, MTD, WTD calculation

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

No, but I'd love to be able to. It would be great if the date range would let you choose the starting date and then select "today" for the end date, so that end date will change as today's date changes.

YTD, MTD, WTD calculation

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

hi all,

 

Any Workaround for this?

 

Thanks

Swathi

Re: YTD, MTD, WTD calculation

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Actually i use this for year to date, yes.

 

 Data-Studio-test2.png

 

Just select on the chart itself (not on the whole report) a specific timeframe:

  • This year
  • This month
  • This week

 Data-Studio-test3.png

 

This will overwrite the specified timeframe of the report for this specific chart

 

Cheers

YTD, MTD, WTD calculation

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

@Steffen K:Thanks for the response.

 

Could you please paste the screenshots in English

Sorry to trouble you

 

Regards,

Swathi

YTD, MTD, WTD calculation

Follower ✭ ☆ ☆
# 6
Follower ✭ ☆ ☆

Swathi - Steffen is using a Scorecard and simply selecting a Custom date range (Benutzerdefiniert) and "This Year" (Dieses Jahr) but you could choose This Week or This Month. Time comparison period is set to None.

 

I can see where it might be handy to specify and have a financial year as an option, but hopefully this works for you.

YTD, MTD, WTD calculation

Participant ✭ ✭ ☆
# 7
Participant ✭ ✭ ☆

The main issue I run into when selecting "this year" is when I've included a comparison to last year. If it's just total numbers for this year, then it works just fun. But if I want the year over year, it comes the total YTD of this year with the entire year last year, which isn't a useful comparison.