Filter chart to specific days of the week

[GregKeith]

Howdy! I have a serial line chart element in a dashboard that shows number of surveys completed per day. This works fine, but surveys are only collected Tuesday, Wednesday and Thursday. Is there a way to limit the chart to just those days, or only days where a survey is completed? Thanks!

[jcarlson · Accepted solution]

You could have your chart based on a Data Expression and convert the day of week to a categorical string field. That way non-present days of the week wouldn't even appear as options.

Is a Data Expression an option for you?

[GregKeith]

Thanks! A data expression would be fine. I'll see if I can figure out how to do that.