8 Replies Latest reply: Oct 3, 2012 9:27 AM by Anuradha Abeysuriya

# Line Chart

I have a line chart,

Demenssion is date,

expression is sales

and i have this data for 5 different countries

i need to create 5 seperate different graphs for those 5 countries.

i know i can do it by putting country and date as a demenssions.

but then i get combine graph.

But i need to get isolated graphs.

Is there any way to do this.

Thanks

• ###### Re: Line Chart

If you want 5 different graphs with one line in each you can either use Set Analysis and hard code one country into each chart.. or look at using trellis charts I guess

• ###### Re: Line Chart

Hi,

Do u want to create seperate chart for different countries....right.... then take Calculated Dimension & write code for that particular country...

for ex: if(Country='India',Country)....Add this exp. into calculated Dimension Field...it will give Data for India Only.

• ###### Re: Line Chart

Thanks,

I have used date as a dimension.

Could you please explan me more deeply

Thanks

• ###### Re: Line Chart

so u can use this exp...

=sum({<Country={'India'}>}Sales)..

it will give data for Country India only

• ###### Re: Line Chart

You can for example use the Trellis option in dimension tab to get separate graphs per country.

Or just create separate chart objects yourself, manually, one for each country.

• ###### Re: Line Chart

Thanks you Very Much,

But i have another additinal question for you

I have countries,

USA

UK

INDIA

CHINA

FRANCE
GERMANY

and Rest Of the world.

Then i can create separate graphs for all above countries using your code.

But i have a problem in rest of the world.

Thanks

• ###### Re: Line Chart

'Rest of the World ' its a value of country Field?....

if yes..then u can use directly...

=sum({<Country={'Rest of the World '}>}Sales)

Another Way is....

=sum({<Country-={'USA','UK','INDIA','CHINA','FRANCE','GERMANY'}>}Sale)

here...it will exclude those country & will give sum of sale for rest of the world......

-= is act as not equal to in set analysis

• ###### Re: Line Chart

Hi I have another Problem,

Here i need to create a "GAUGE Chart" for above Thing, But the problem is i only want it for latest date

Max(Date),

How can i create a GAUGE Chart for display only max date data