Loading...
X

Set Analysis Measure for Deals

List of set analysis measure created in Master Item under Measures

Deal Appointment Closing Ratio MTD

Description:  Number Of Appointments Scheduled On Sold Deals Divided By Number Of Appointments Scheduled.   Scheduled Date of Appointment Is Current Month To Date.

Expression:

Count({$<$(vWPToDoScheduledMTD), $(vWPToDoIsAppointment), $(vDealSoldOrDelivered)>}$(cWPToDoID))
/
Count({$<$(vWPToDoScheduledMTD), $(vWPToDoIsAppointment)>}$(cWPToDoID))


Deal Appointment Closing Ratio w Source YTD

Description:  Number Of Appointments Scheduled On Sold Deals Divided By Number Of Appointments Scheduled.  Deals Must Have A Source Entered.  Scheduled Date of Appointment Is Current Year To Date.

Expression:

Count({$<$(vWPToDoScheduledYTD) ,$(vWPToDoIsAppointment), $(vDealSoldOrDelivered), $(vDealIsFromSource)>}$(cWPToDoID))
/
Count({$<$(vWPToDoScheduledYTD), $(vWPToDoIsAppointment), $(vDealIsFromSource)>}$(cWPToDoID))


Deal Appointment Closing Ratio w Source YTD

Description:  Number Of Appointments Scheduled On Sold Deals Divided By Number Of Appointments Scheduled.  Deals Must Have A Source Entered.  Scheduled Date of Appointment Is Current Year To Date.

Expression:

Count({$<$(vWPToDoScheduledYTD), $(vWPToDoIsAppointment), $(vDealSoldOrDelivered), $(vDealIsFromSource)>}$(cWPToDoID))
/
Count({$<$(vWPToDoScheduledYTD), $(vWPToDoIsAppointment), $(vDealIsFromSource)>}$(cWPToDoID))


Deal Appointment Closing Ratio YTD

Description:  Number Of Appointments Scheduled On Sold Deals Divided By Number Of Appointments Scheduled.   Scheduled Date of Appointment Is Current Year To Date.

Expression:

Count({$<$(vWPToDoScheduledYTD), $(vWPToDoIsAppointment), $(vDealSoldOrDelivered)>} $(cWPToDoID))
/
Count({$<$(vWPToDoScheduledYTD), $(vWPToDoIsAppointment)>} $(cWPToDoID))


Deal Appointment Count MTD

Description:  Count of The Number of Appointment Action Type Of ToDos From Deals.  Appointment Is Scheduled For Current Month To Date.

Expression:

Count(distinct{$<$(vWPToDoScheduledMTD), $(vWPToDoIsAppointment)>} $(cWPToDoID))


Deal Appointment Count MTD w Source

Description:  Count of The Number of Appointment Action Type Of ToDos From Deals.  Appointment Is Scheduled For Current Month To Date. Deal Must Have Source Entered.

Expression:

Count(distinct{$<$(vWPToDoScheduledMTD), $(vWPToDoIsAppointment), $(vDealIsFromSource)>} $(cWPToDoID))


Deal Appointment Count YTD

Description:  Count of The Number of Appointment Action Type Of ToDos From Deals.  Appointment Is Scheduled For Current Year To Date.

Expression:

Count(distinct{$<$(vWPToDoScheduledYTD), $(vWPToDoIsAppointment)>} $(cWPToDoID))


Deal Appointment Count MTD w Source

Description:  Count of The Number of Appointment Action Type Of ToDos From Deals.  Appointment Is Scheduled For Current Month To Date. Deal Must Have Source Entered.

Expression:

Count(distinct{$<$(vWPToDoScheduledMTD), $(vWPToDoIsAppointment), $(vDealIsFromSource)>} $(cWPToDoID))


Deal Appointments No Show MTD

Description:  Count Of The Number Of Appointments On Deals That Have Been Marked As Cancelled.  Scheduled Date Of Appointment Is Current Month To Date.

Expression:

Count({$<$(vWPToDoScheduledMTD), $(vWPToDoIsAppointment), $(vWPToDoStatusCancelled)>} $(cWPToDoID))


Deal Appointments No Show MTD w Source

Description:  Count Of The Number Of Appointments On Deals That Have Been Marked As Cancelled.  Scheduled Date Of Appointment Is Current Month To Date.  Deal Must Have Source Entered.

Expression:

Count({$<$(vWPToDoScheduledMTD), $(vWPToDoIsAppointment), $(vWPToDoStatusCancelled), $(vDealIsFromSource)>}$(cWPToDoID))

 


Search:  Count, Distinct

Subscribe Now

Get BI Blog updates straight to your inbox

Name *

Email *