Filter for dashboard to select weekdays | XM Community
Skip to main content
Solved

Filter for dashboard to select weekdays


praveengeorgeix
QPN Level 4 ●●●●
Forum|alt.badge.img+11

Is there a way to create a date filter in dashboard to exclude a particular weekday.

For example,

I need the filter to

exclude all “Saturdays”

or

choose “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday” and “Sunday”

 

Thank you,

Praveen

Best answer by Nam Nguyen

praveengeorgeix wrote:

This is an ongoing survey. It will be live for another 4-5 years.

 

@praveengeorgeix Your survey will be live for a long time, so I suggest you to follow an optimal solution.
For future distribution, you can follow this post to add weekday as embedded data in the survey

For already collected data, i’m affraid you have to edit them with excel function and import them back for the field to be connected with future data.
Hope this helps

View original

5 replies

Forum|alt.badge.img+14
  • Level 5 ●●●●●
  • 276 replies
  • October 17, 2023

Is this for an ongoing survey throughout the year, or is it for a survey that lasts just one or two weeks? If the timeframe for the survey is short, you could probably use recoded values to recode dates as Weekday vs. weekend in a field variable.


praveengeorgeix
QPN Level 4 ●●●●
Forum|alt.badge.img+11
  • Author
  • QPN Level 4 ●●●●
  • 99 replies
  • October 17, 2023

This is an ongoing survey. It will be live for another 4-5 years.

 


Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • 1091 replies
  • Answer
  • October 18, 2023
praveengeorgeix wrote:

This is an ongoing survey. It will be live for another 4-5 years.

 

@praveengeorgeix Your survey will be live for a long time, so I suggest you to follow an optimal solution.
For future distribution, you can follow this post to add weekday as embedded data in the survey

For already collected data, i’m affraid you have to edit them with excel function and import them back for the field to be connected with future data.
Hope this helps


praveengeorgeix
QPN Level 4 ●●●●
Forum|alt.badge.img+11
  • Author
  • QPN Level 4 ●●●●
  • 99 replies
  • October 23, 2023

Thank you @dxconnamnguyen 


Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • 1091 replies
  • October 23, 2023
praveengeorgeix wrote:

Thank you @dxconnamnguyen 

Happy to helps 👍


Leave a Reply