I would like to show a trend using only Fridays

user07761

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

Valiant

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.

Valiant

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.

user07761

That worked! Thank you for the help.