Last full day only

Dpritykin
Dpritykin Member
in Charting

Hello, 

 

I would like to create cards that show data for the past 7 full days only ( without showing today's data) and have that card update it self automaticly as the day ends. Right now the only way i can do that is through creating a new data set that allows me for this manipulation. However, that forces me to creat multple datasets with the exact same data ( one for dynamic or live data and one for static or full day data). 

 

Is there a way to do this on a card level rather than on the dataset level? 

 

Thank you

Best Answer

  • Godiepi
    Godiepi Coach
    Answer ✓

    You can create a beastmode to be added as a filter that reads

     

    CASE
    WHEN `YourDate` = CURRENT_DATE() then 'No'
    ELSE 'Yes' END

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'

Answers

  • Godiepi
    Godiepi Coach
    Answer ✓

    You can create a beastmode to be added as a filter that reads

     

    CASE
    WHEN `YourDate` = CURRENT_DATE() then 'No'
    ELSE 'Yes' END

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • Dpritykin
    Dpritykin Member

    Thanks 

  • Dpritykin
    Dpritykin Member

    upload.png

    Is there way to get rid of the today's collumn? 

  • Godiepi
    Godiepi Coach

    Make sure to add the beastmode as a Filter so that the last Date does not show up at all

    Screen Shot 07-27-16 at 12.34 PM.PNG

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.

Categories