How to limit data so that is is greater than today

gg
gg Member
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 Contributor
    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

  • cmarkum
    cmarkum Contributor
    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. 

  • gg
    gg Member

    This will work, thank you.

This discussion has been closed.

Categories