Filter chart to specific days of the week

80
2
Jump to solution
08-01-2022 09:04 AM
Labels (1)
GregKeith
New Contributor III

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!

0 Kudos
1 Solution

Accepted Solutions
jcarlson
MVP Notable Contributor

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?

- Josh Carlson
Kendall County GIS

View solution in original post

2 Replies
jcarlson
MVP Notable Contributor

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?

- Josh Carlson
Kendall County GIS
GregKeith
New Contributor III

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

0 Kudos