how to write this expression

[kunkumnaveen]

Hello All,

if i got table like below

suppiler          code      date

            a                    A              01/01/2015

            b                    A                12/03/2015

            c                    B                02/01/2015

              d                    A+        2 0/03/2016

              a                    A+              31/03/2016

            b                    B              31/03/2016

            c                    C              31/03/2016

            d                    A+        31/03/2016

            e                    A+        31/03/2016

so what i am looking  is  :in a pie chart i need to show count of each  code based up on there suppliers  latest date

i mean output:  in a pie chart :dimension= code

                                            expression:?(what shou;d i need to write)

result table:                      code  count(supplier)

                                        A        0  (supplier 'a' latest score is A+)

                                        A+      3

                                        B      1

                                        C        1

thanks

naveen

[kaushiknsolanki]

Hi,

You can add set analysis in expression like below.

count({<Role = {"eval"}>}code)

Regards,

Kaushik Solanki

[Kushal_Chawda]

Dimension: Supplier

Expression:

Code-  FirstSortedValue(0nly({<Role={'Eval'}>}Code), -Date)

[sunny_talwar]

Updated sample attached