Current day vs same week day last week

Hi is there anyway to get say Thursday this week vs Thursday last week view in a card, without having to create a dataflow to restrict data ?

 

View expected

 

Thursday 1st September Values

Thursday 26th August    Values

 

 

Best Answer

  • shaanarora
    Accepted Answer

    Your best bet is probably just to add a Beast Mode column that includes only those two dates. Example:

     

    CASE

    WHEN DATEDIFF(CURRENT_DATE(),`Date Field`)  = 0 OR DATEDIFF(CURRENT_DATE(),`Date Field`)  = 7 THEN 'Include'

    ELSE 'Exclude'

    END

     

    Then filter that field to 'Include' rows.

Answers

This discussion has been closed.