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
Black 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
Black 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
Looking for the latest Dojo Community solutions? Click on the "NEW SOLUTIONS' widget title or go to https://dojo.domo.com/solutions Click here!