chart manipulation

[#1]

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

[giakoum]

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

[#3]

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

[giakoum]

You can combine eventid and eventname as a dimension so that you have a unique reference :

eventid & ' ' & eventname

[#5 · Accepted solution]

Try this,

Dimension : EventName

Expression : =aggr(max(Cost),EventName)

[#6]

yeah thats giving the right statistics, but the user is not interested in the eventids, how to hide the eventid from the dimension

[#7]

Then, dont take Eventid in the dimension . What is the final fomat expected here..?

[#8]

Thanks yogan, ur answer solved the problem