Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table, having events with different date but same name, i want to calculate event with highest cost, i need to show events having highest investment in a chart
EventId | EventName | Date | Cost |
---|---|---|---|
event1 | ABC event | 1.1.2011 | 1000 |
event2 | ABC event | 15.2.2011 | 3000 |
event3 | XYZ event | 27.3.2011 | 2000 |
Try this,
Dimension : EventName
Expression : =aggr(max(Cost),EventName)
Hi.
this sounds easy so maybe I am missing something here.
Create a bar chart, sorted by cost desc and there you go. You can combine eventid and eventname as a dimension so that you have a unique reference.
BR, Ioannis
yeah it should be a simple one, but its not working rite, its a bar chart, i can have event id as dimension and cost as expression, but the problem is that i have to show the event name on dimension
i have taken bar chart, event name as dimension and cost as expression, it is summing the cost up for the event name which is not the true picture
You can combine eventid and eventname as a dimension so that you have a unique reference :
eventid & ' ' & eventname
Try this,
Dimension : EventName
Expression : =aggr(max(Cost),EventName)
yeah thats giving the right statistics, but the user is not interested in the eventids, how to hide the eventid from the dimension
Then, dont take Eventid in the dimension . What is the final fomat expected here..?
Thanks yogan, ur answer solved the problem