calculated dimension expression issue

[buzzy996]

hi guys,

Dim1: Supplier name

Dim2: this is my calculated dimension "=If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>='6','SLAs Not Met','SLAs Met')"

expression is : Count(unique num)

Result: results are appearing good as per the expectation but when i tried to click on second dimension legend on chart either SLAs Met or SLAs Not Met, for example if I click on SLAs met it appearing all SLAs Met and 1 or 2 case results of SLAs Not Met as well!!!,so here SLAs Not met should't appear.

any help?

thanks

[buzzy996]

sunny, i replace the above expression,received "Allocated memory exceeded".

any help?

[sunny_talwar]

What about this:

=Aggr(If(Networkdays(Only({1} Scheduled_Send_Time__c), Only({1} Delivery_Acknowledged_Time__c), $(ListOfHolydays)) >= '6', 'SLAs Not Met', 'SLAs Met'), [Supplier name])

[Kushal_Chawda]

or try using Valuelist function

Dim1: Supplier name

Dim1: Valuelist('SLAs Met','SLAs Not Met')

Expression:

Pick(match(Valuelist('SLAs Met','SLAs Not Met'),'SLAs Met','SLAs Not Met'),

Count(If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))<'6',unique num)),

Count(If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>='6',unique num)))

[Digvijay_Singh]

Try to see the value of  below section in text box and check how it is changing based on selection, you may get some new ideas -

Concat(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays)),chr(13)

[buzzy996]

same as above, no data to display.

[sunny_talwar]

Do you have a sample you can share?

[Kushal_Chawda]

Have you tried this?

[buzzy996]

will try suny,if it's possible i'll share.

pls let me know,if u have any other way we can do?

[sunny_talwar]

Kush suggested ValueList above, I guess give that a try

[buzzy996]

hi kush,sorry for the late reply..i tried this it not given the expected result and not allowed to select either SLAs Met or Not from legends as well.

any other way to do?