I would like to show a trend using only Fridays

user07761
user07761 Member
in Charting

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

Best Answer

  • BlueRooster
    BlueRooster Domo Employee
    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.

Answers

  • BlueRooster
    BlueRooster Domo Employee
    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.

  • user07761
    user07761 Member

    That worked! Thank you for the help.

This discussion has been closed.

Categories