AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Time series report with 2 filters - Help me please

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

I'm trying to build a time series report, with two filters.

I have two columns with dates - one for "date of installation", and for "current date".

 

I want the report to behave like that:

x axis - current date (for e.g 1/7/17, 2/7/17,3/7/17 etc)

y axis - number of active users (the inactives are irrelevant)

 

filter 1 - choose installation date

filter 2 - choose current date (and by default show all current dates on x axis)

 

Then, we can see if users that installed our software on May 4th 2017, are still active on July, and so on..

 

Can someone please assist in this kind of report?

 

Many Thanks

Yael