Hello Community!
I am creating a KPI where I am looking to count records from start of year through today. The one issue I am facing is that my dates are coming in through a date bridge and so I have to specify my syntax that way in the Set Analysis expression:
= Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'}>}Gateways)
I saw the below expression from one of the other blogs:
=Count({<TStartDate={"$(='>=' & Date(Today(), 'DateFieldFormatHere') & '<=' & Date(Today()+14, 'DateFieldFormatHere'))"}>} TCode)
but I am unsure of how to restructure my expression because of "[Date Type]={'VPP Dates'}"
Any help rendered will be truly appreciated.