7 Replies Latest reply: Jun 29, 2012 2:36 AM by sidrahasan

# chart manipulation

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

EventIdEventNameDateCost
event1ABC event1.1.20111000
event2ABC event15.2.20113000
event3XYZ event27.3.20112000
• ###### Re: chart manipulation

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

• ###### Re: chart manipulation

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

• ###### Re: chart manipulation

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

eventid & ' ' & eventname

• ###### Re: chart manipulation

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

• ###### Re: chart manipulation

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

• ###### Re: chart manipulation

Thanks yogan, ur answer solved the problem

• ###### Re: chart manipulation

Try this,

Dimension : EventName

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