I would like to show a trend using only Fridays
Best Answer
-
You could use the DAYOFWEEK() function to do this.
https://www.w3schools.com/sql/func_mysql_dayofweek.asp
A filter for this might look like:
CASE WHEN DAYOFWEEK(`date_column`) = 6 THEN 1 ELSE 0 END
Then filter it on is equal to 1.
That will only allow Friday dates in your card.
Hope that helps,
Valiant
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Answers
-
That worked! Thank you for the help.
1
This discussion has been closed.
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部