Line Chart

[anuradhaa]

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

[Anonymous]

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

[#3]

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.

[swuehl]

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.

[anuradhaa]

Thanks,

I have used date as a dimension.

Could you please explan me more deeply

Thanks

[#6 · Accepted solution]

so u can use this exp...

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

it will give data for Country India only

[anuradhaa]

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.

Could you please help me in this.

Thanks

[#8]

'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

[anuradhaa]

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