chart expression

[buzzy996]

hi,the below syntax is working perfectly fine with straight table but i need to implement the same on chart and most important " need to consider only met possible records" on chart .

=IF(

      IF(Len(ord_Date_Time__c)<1,

          Date(Today(),'dd/MM/yyyy'),Date(ord_Date_Time__c,'dd/MM/yyyy')

         )

        < Date(IDate__c + If(Agent='PTO','28','91'),'dd/MM/yyyy'),'Met','Not Met'

      )

 thanks in advance

[bgerchikov]

First, I'd avoid to use formatted Dates. Try to use numeric values.

If you want to exclude 'No Met' values, use Null() instead and set to exclude Null values in chart

=IF(
      IF(Len(ord_Date_Time__c)<1,
          Floor(Num(Today())),Floor(Date(ord_Date_Time__c))
         )
        < (Num(IDate__c) + If(Agent='PTO',28,91)),'Met',Null()
      )

Good luck!

[buzzy996]

hi,thanks for this but it's not helped to me because need to use on expression tab (not on dimension tab to control null values)

 I just need to count of all met from the above expression on bar chart & tht to on expression tab.

any other idea?

[sunny_talwar]

May be try this

=Count(If(If(Len(ord_Date_Time__c) < 1, Today(), ord_Date_Time__c) < (IDate__c + If(Agent = 'PTO','28','91')), 'Met'))

or this

=Count(If(Alt(ord_Date_Time__c, Today()) < (IDate__c + If(Agent = 'PTO','28','91')), 'Met'))

[bgerchikov]

I see. What about this:

=Sum(
      IF(Len(ord_Date_Time__c)<1,
          Floor(Num(Today())),Floor(Date(ord_Date_Time__c))
         )
        < (Num(IDate__c) + If(Agent='PTO',28,91)),1
      )