Filter chart to specific days of the week

Question

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 Answer

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?