Set Analysis Query..

[MuraliPrasath]

Hi,

Can someone help me correct this Set Analysis

Count({$<ShipmentStatus={'READY'}, DATE={$(=Today())'}>}DISTINCT(CarrierID))

My Requirement is Count of Distinct 'CarrierID' based on ShipmentStatus='READY' for only Today.

How to achieve this?

[swuehl]

maybe there is just a single quote missing in DATE set modifier:

Count({$<ShipmentStatus={'READY'}, DATE={'$(=Today())'}>}DISTINCT(CarrierID))

[sunny_talwar]

May be this:

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(), 'YourDATEFieldFormat))"}>}DISTINCT(CarrierID))

[MuraliPrasath]

Still no luck !!  My Date fileld name is DATE..

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'DATE'))"}>}DISTINCT(CarrierID))

[sunny_talwar]

Not DATE here

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'DATE'))"}>}DISTINCT(CarrierID))

but the format, like MM/DD/YYYY or DD/MM/YYYY or DD-MMM-YYYY. Whatever format DATE has, need to go within the single quotes.

HTH

Best,

Sunny

[MuraliPrasath]

Hi Sunny,

Still no luck!!

Count({$<ShipmentStatus={'READY'}, DATE={"$(=Date(Today(),'MM/DD/YYYY'))"}>}DISTINCT(CarrierID))

[sunny_talwar]

Have you made sure that you have CarrierID for today's date where ShipmentStatus = 'READY'??

[avinashelite]

have you checked the variable value what your getting ?? and make sure that both the dates have the same format

[MuraliPrasath · Accepted solution]

Hi Sunny,

Finally this is worked. Thank you.

Count({$<ShipmentStatus={'READY'}, DATE={"=date($(vToday))"}>}DISTINCT(CarrierID))