
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Before a date
Attached i have a snap shot of a straight table. I am trying to eliminate any date before the date Today - 2 days (Two Days Ago).
Below is the expression that gave me the snap shot of the straight table.
Count({<DEPT={"44840"}, epic_status-= {"Not Required", "Done"}, project_name-={"PMO IMS Pipeline","PMO Test"}>}issue_due_date)
I need to add something like "issue_due_date >= today()-2" somewhere into equation above.
Can anyone tell me how I can get this ("issue_due_date >= today()-2") into the above equation?
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you all for your help I found the solution to my problem. Below are the two expressions i used to solve my problem
Exprssion:
Count({<DEPT={"44840"}, epic_status-= {"Not Required", "Done"}, project_name-={"PMO IMS Pipeline","PMO Test"}>}epic_summary)
Calculated Deminsion:
=Date(If(epic_due_date>=today()-2,epic_due_date),'MM/DD/YYYY')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this?
= Count({<DEPT={"44840"}, epic_status-= {"Not Required", "Done"},
project_name-={"PMO IMS Pipeline","PMO Test"},
issue_due_date = {"$(= '>='&Date(Today()-2, 'MM/DD/YYYY hh:mm:ss fff')) "} >}issue_due_date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I tried it and it doesn't work my straight table displays nothing when this is added.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be as below:
Count({<DEPT={"44840"}, epic_status-= {"Not Required", "Done"}, project_name-={"PMO IMS Pipeline","PMO Test"},issue_due_date={"$(= '>=' &Date(floor(Issue_Due_Date)-2)) "}>} issue_due_date)


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this?
= Count({<DEPT={"44840"}, epic_status-= {"Not Required", "Done"},
project_name-={"PMO IMS Pipeline","PMO Test"},
issue_due_date = {"$(= '>='&Date(Max(issue_due_date)-2, 'MM/DD/YYYY hh:mm:ss fff')) "} >}issue_due_date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
did not work displaying nothing.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No this did not work either


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you share a sample to look into? And your expected output?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you give a try on the below:
Count({<DEPT={"44840"}, epic_status-= {"Not Required", "Done"}, project_name-={"PMO IMS Pipeline","PMO Test"},issue_due_date={"$(='>='&Date(floor(issue_due_date)-2))"}>} issue_due_date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So that expression displays data but it is the same as the original straight table i snap shot in the beginning of this thread.

- « Previous Replies
-
- 1
- 2
- Next Replies »