Date range control to show records that do NOT match date range

[mediadesign]

Hello,

I have set up a page in Looker Studio which is linked to a Google Sheet which contains a date for all users who have logged into my application within the date range, using the Last Login date field from my sheet to match the records, this is straight forward to show active users who logged in within the set date range.

I am now trying to set up the opposite of this on a page to show the inactive users who did NOT log in within the set date range. Is there a way so that when the date range is selected from the dropdown that my table shows all records that do NOT match the date range?

Thanks

[dylantrose]

Hey Mediadesign,

There currently isn't a way to change how the Date Range Control works.

However, you could try doing this:

Create a date spine for the dataset, with each day having a column per user that is either true or false for whether they logged in that day. This can be accomplished with some savvy Google Sheets work. Alternatively, you could have every date per user and a true or false column if they logged in during that month or not. Then you could set up two separate charts that show the people who logged in or people who didn't log in through a filter.

Hope this helps,

Dylan