3 Months data in report - 1st Month is user selection in a Filter

[Ramakrishna]

Have a requirement to display 3 Months of data in looker dashboard

1st Month is selected by user using a month Filter. Next subsequent two months Table visuals have to be displyed based on filter selection. For Example If user selects Dec. Dashboard should have Dec, Jan and Feb in Table visuals

Can anyone help with this ?

[lsolatorio]

Hi @Ramakrishna,  

In Google Sheet, this method is achievable using helper columns, formulas and/ or app script, with Looker Studio however, a different approach needs to be implemented because the tool's dynamics are different as well, your data will mostly be relying on filters/ control objects.

Here's some tips that you can follow:

1. Arrange your data in raw form, make sure you have all the items needed for filtering such as the year, month and date
2. Connect your source (Google Sheet) to Looker Studio
3. Create your table; choose your Dimensions and Metrics
4. Choose from a variety of control objects for filtering

• Drop-down list - The most basic control you can use, offering a list and check boxes where you can select your months
• Input Box - Select a numerical dimension (month number) so you can use the between function
• Slider - Requires numerical data (month number) to control the data in your table
• Date range control - Needs a date dimension to function properly, you can choose from pre-defined functions like This Quarter or Last Quarter to get your 3 months worth of data

You can use these control objects to set the number of months you need in your table and in case you need more months for comparing data.

ss_1_source_raw_form

ss_2_controls_sample_setup

Hope this helps.