Omitting Weekends from Daily Counts
Is there anyway I can easily exclude weekends and only show week days in a vertical bar chart of twitter post counts? For example I want to check we are posting at least 3 times a day on twitter, so have the goal set at three, but the chart shows all days including weekends.
Thanks.
Comments
-
Yes , you can do it through a beastmode.
CASE WHEN DAYNAME(`TransactionDate`) IN ('Saturday', 'Sunday') THEN 'NO' ELSE 'YES' END
Then you can add this as a filter and it will get rid off the Saturdays and Sundays
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Base on the screenshot it is working , bars are showing zeros for September 3 , 4 , 10 , 11 etc which are Saturdays and Sundays. so, it is not including weekends for the counts.
now, to make a date display as name of days , that would need to be created as a different beastmode.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Thanks for reply - yes correct but I don't want them on the graph, its those I want removed so the graph only shows data for weekdays.
Thanks.
0 -
Yes , I think that you added the code I gave you to your count beastmode. add it as a filter and that will force the chart to display only weekdays and hide the weekends. but since the date is present in your data the chart might still make it show up.
have you tried created a data flow that only includes weekdays ? that might work
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive