- Count of the Requests (object created in previously) submitted by the contact in the last 90 days for which the contact is also the Owner of the Request
Like
1 comments
20:54 Jun 17, 2019
Hello!
Unfortunately, in the system you can't build filter as Object.Column1 = Object.Column2. You can implement this task with 2 ways:
1) If you need to do it only once you can write an sql query,
select count (*) from <Request table name> where Owner=Contact and CreatedOn > (SELECT getdate() - 30)
2) If you need to keep this metric you can create database view on Request table, after that create an object out of database view in bpm online
https://academy.bpmonline.com/documents/technic-sdk/7-13/localizing-views?_ga=2.82466582.1097619040.1560787229-512856358.1560787229
After that you can create a metric chart comparing the Request's Owner to the View's Contact for the same record.
Best regards,
Dennis
Show all comments