Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

How to apply a filter in chart where you can count a value based on all the dates less than today?

Answered
0

Comments

3 comments

  • Jenna Pettyjohn
    Hi Vinit,

    I'm looking into this question for you.  Do you have a report that contains the information regarding dates?  Controls do not generally have their own "due date" which would not allow for a filter as you are speaking-- unless this is data that you have compiled?  I would be happy to keep digging into this, just hoping to have a little more clarification so we can be on the same page in finding our solution!
    0
  • Vinit Malviya, CISA
    Yes I do have a report which has control and the due dates. I am trying to create a chart where I can show .controls past due. For that I have to use a functionality where it can count all the control where due date is before today.
    0
  • Jenna Pettyjohn
    Hey Vinit,

    I have been discussing this matter with your Customer Success Manager, and he is going to touch-base and explain this to you all a little deeper-- but for a quick rundown from what we have discussed, we cannot build "logic" into database reports, but you would be able to use a connected sheet, which gets database information into Spreadsheets!


    0

Please sign in to leave a comment.