I would like to show a trend using only Fridays

Reply
Visitor

I would like to show a trend using only Fridays

I would like to show a trend using only Fridays, not sure how to filter my data for this. My date format is mm/dd/yyyy.

 

Thank you,

Jonny


Accepted Solutions
Highlighted
Major Red Belt

Re: I would like to show a trend using only Fridays

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.


All Replies
Highlighted
Major Red Belt

Re: I would like to show a trend using only Fridays

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.

Visitor

Re: I would like to show a trend using only Fridays

That worked! Thank you for the help.

Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!