Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
= count(Max(Date)
=count(Max(Distinct Date),Supplier))
This?
Dimension: =Aggr(FirstSortedValue(code, -date), suppiler)
Expression: =Count(DISTINCT supplier)
Hi!
dimension: code
expression: count({<date={"$(=date(max({1} date)))"}>}suppiler)
Hello
its not working in my case ,can you suggest anything diff
can you share your example or post some features of your script or app
What isn't working? Can you share your case because I have no idea why this isn't working for you
A small change in my requirement
suppiler code date role
a A 01/01/2015 eval
a A+ 01/01/2015 self
b A 12/03/2015 eval
b A 12/03/2015 self
a A+ 31/03/2016 eval
a A+ 31/03/2016 self
b B 31/03/2016 eval
b B+ 31/03/2016 self
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 and whose role is eval only
o/p:
suppiler count(code)
a 1(A+)
b 1 (B)
Dimension: =Aggr(FirstSortedValue(code, -date), suppiler)
Expression: =Count(DISTINCT supplier)
how to add role={'eval'} in the above expression ...
please
May be this:
Dimension: =Aggr(FirstSortedValue(role={'eval'} code, -date), suppiler)
Expression: =Count(role={'eval'} DISTINCT supplier)
Dimension: =Aggr(FirstSortedValue({<role={'eval'}>} code, -date), suppiler)
Expression: =Count({<role={'eval'}>} DISTINCT supplier)