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.
Best Answer
-
@user048760 Yes, using SUM would change the sorting. Click on the pencil icon to edit the sorting criteria and choose No Aggregation. That should fix your issue.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Answers
-
Do you have any other fields in your Sorting properties? Or is the dayofweek beast mode field the only field that is in the Sorting properties?
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass It is only that daysofweek beast mode, but it is aggregated 'Sum' in the filtering field I'm not sure if that has any influence. I just saw it and thought it was peculiar.
0 -
@user048760 Yes, using SUM would change the sorting. Click on the pencil icon to edit the sorting criteria and choose No Aggregation. That should fix your issue.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 256 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 500 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 372 Beast Mode
- 19 Variables
- 483 Automate
- 101 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive