Formula to get data from previous month in Google Data Studio

So I'm trying to get the same data (Clicks Jan, Clicks Feb) to display as shown in the picture below. My first guess was to create a new field using the formula feature. Is there anyone that knows what the formula may look like?

The functions list: https://support.google.com/datastudio/table/6379764?hl=en&ref_topic=7570421&authuser=0

enter image description here Using the "New field" feature

You can use this formula while creating a column to filter out dates in the last month and create a filter using this column.

CASE
  WHEN "Date column name" < DATETIME_TRUNC(TODAY(), MONTH) AND "Date column name" >= DATETIME_TRUNC(DATETIME_SUB(TODAY(), INTERVAL 1 MONTH), MONTH) THEN 1
  ELSE NULL
END

Formula to get data from previous month in Google Data Studio

Related

Recent Posts