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

Filter for dashboard to select weekdays

  • Oct 17, 2023 8:24 PM UTC
  • 5 replies
  • 108 views

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

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 ●●●●●
  • Oct 17, 2023 8:33 PM UTC

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 ●●●●
  • Oct 17, 2023 8:44 PM UTC

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 ●●●●●●●●
  • Answer
  • Oct 18, 2023 4:17 PM UTC

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 ●●●●
  • Oct 23, 2023 2:09 PM UTC

Thank you @dxconnamnguyen 


Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • QPN Level 8 ●●●●●●●●
  • Oct 23, 2023 3:19 PM UTC

Thank you @dxconnamnguyen 

Happy to helps 👍