+ Start a Discussion
Kevin CharetteKevin Charette 

Need to track highest achieved picklist value.

I am working on getting a field that tracks the picklest values of another field. I want it to tell me what is the highest value that the picklist field has ever acheived. This is for a lead/contact field. In this example, I am tracking a lifecycle of a lead/contact.

My picklist values, in the order of achievement, are:

PROSPECT
INACTIVE FREE
FREE TRIAL
FREE ACTIVE
CUSTOMER BUSINESS
CUSTOMER PRO
CUSTOMER ENTERPRISE

Any help on this would be appreciated. I am currently tracking the field history of this field in both the contact and lead. 

Thank you in advance!

Kevin
jigarshahjigarshah
Kevin, this appexchange product can help address your issue. The product helps you slice and dice and extract Excel based reports which you can leverage to determine the metric that you intend to track.

Ultra FieldHistory Tracker - https://appexchange.salesforce.com/listingDetail?listingId=a0N3A00000DrzkrUAB

Hope this helps. Let me know if you need further help around the same.

Please mark this thread as SOLVED and the answer that best helps you resolve your issue, as the BEST ANSWER.
buggs sfdcbuggs sfdc
kevin,

why dont you try a soql query on the base of picklist value and see how many records are there with that type, the highest count will be highly acheived.

select id,type from sobject where type = 'PROSPECT'

repeat it same for all values,and check the record count.

Hope it will help you.