Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have different vehicles with different cost and I want to obtain the number of vehicle with max cost.
Thanks
Not sure I understand completely, but may be this:
Count({<Cost = {$(=Max(Cost))}>} Vechicle)
Thank you Sunny, but it returns the total nº of vehicles...
For one city (ex Barcelona) I have 25 vehicles (a, b, c, d....) and each vehicle has a cost. I want for Barcelona the letter of vehicle with max cost.
May be this
Dimension:
City
Expression:
FirstSortedValue(letter, -Cost)
Thank you, it works!
And now it would be possible to represent as a pot each vehicle in the following chart? now it only shows the vehicle with max cost and I would like to show the different vehicles to see cost distribution in the city:
Not sure I understand what you are looking for?
And now it would be possible to represent as a pot each vehicle in the following chart? now it only shows the vehicle with max cost and I would like to show the different vehicles to see cost distribution in the city
I would like to show in X axis the city id, in Y axis maximun cost of the vehicle and in the pots the diferent vehicles (a, b,c) for each city. to see the differences between cities and the cost of the vehicles.
Maybe it is not possible...