How to limit data so that is is greater than today

gg
gg ⚪️
in Charting

I am trying to accomplish having my limit data be greater than or equal to today.  How can I accomplish this?  Thanks

 

gt_today.PNG

Best Answer

  • cmarkum
    cmarkum 🟢
    Answer ✓

    You can't enter a formula in the "Limit Data" on the date in the card. This would be a great idea to post in the Idea Exchange though!

     

    You would have to create a Beast Mode calculation and use that as a filter. 

     

    CASE WHEN `DATE` >=CURDATE() then 1 else 0 end

     

    and then just add that to the filters area and filter for 1. 

Answers

This discussion has been closed.

Categories