Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please let me know the set expression for below scenario.
I want to show the top Driver name who has driven highest Green kms travelled.
One text object should show Driver Name another Green Kms travelled. Expression for Green km Travelled - =sum({<DriverClassification={'SGreen'}>}[Kms Travelled]). Given in Straight table.
from Below straight table. I need show the name Rakesh Kumar (highest kms travelled) and in one more text object we need show kms travelled that value 43078.
thanks in advance
This expression in a text box should give you RAKESH KUMAR:
=Only( {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Driver Name] )
This expression in another text box should give you 43078:
=Sum( {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Kms Travelled] )
This expression in a text box should give you RAKESH KUMAR:
=Only( {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Driver Name] )
This expression in another text box should give you 43078:
=Sum( {<[Driver Name]={"=Rank(Sum({<DriverClassification={'SGreen'}>} [Kms Travelled]))=1"}>} [Kms Travelled] )
Thanks for your response Petter,
Expression ok but its not giving the output.
Here my intention is need show all the drvier names like below.. Please suggest another expression.
Thanks Petter, its working now properly.