Exclude dates in Dashboard | XM Community
Solved

Exclude dates in Dashboard

  • 11 June 2019
  • 2 replies
  • 37 views

Userlevel 1
Hello,

I am trying to exclude a specific month from my Dashboard data, while still allowing people to use date as a filter.
(I.e. exclude December data, while allowing people to filter on any date they want, ex: past month or past year).

I tried in the settings, or by adding a specific date filter on the tab, but I wasn't successful. I was thinking of creating a new embedded data with 0/1 value (0 = December data, 1 = rest of the data), and add that new variable as a locked filter.

Any other solution you would recommend?

Thanks so much in advance!
icon

Best answer by Akdashboard 11 June 2019, 22:42

View original

2 replies

Userlevel 7
Badge +6
You need to add an indicator to the data sources and use that as a way to filter in the dashboard.

I'd go to the individual project(s) and add a new embedded data field in the survey flow (something like Valid_Indicator or whatever makes sense) then edit all the responses for December to be Valid_Indicator=False and all other responses to Valid_Indicator-True. Then in your dashboard add a locked filter of Valid_Indicator=True.

Note - You won't see the new embedded data field you added until a survey is a collected. You can trigger this by going through the preview link.
Userlevel 1
Thanks so much! That's what I thought, but I wanted a second opinion before editing all my answers and projects (I have a lot...)!

Leave a Reply