How to apply a filter in chart where you can count a value based on all the dates less than today?
AnsweredWdesk Internal Audit - I want to create a bar chart to display all past due controls. I do not find any filter which can filter dates less than today. Is there a way to do it? - Wdesk Version 1.5.1166
0
-
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!0Yes 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. 0Hey 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!0Please sign in to leave a comment.
Comments
3 comments