Odd sorting issue when filtering
I have a card that displays the average leads per day of the week. To sort the days of the week in a chronological order I used dayofweek(`date_entered`) beast mode calculation to get the days of the week detail. Unfiltered everything looks good gives the average for each day of the week, Sunday - Monday. Once you filter, like say to region or channel it throws the sorting off and things fall out of chronological order. I'm not sure exactly why this is happening. any suggestions, or insight would be appreciated.