Split line chart y-axix

[#1]

Hello,

Ive got this line chart:

As you can see the light green is high on the line graph. And the rest is down in the buttom because they have low values.

Is it possible to split the graph?

Eg. from 0 to 1000 it would be 0 - 100 and then from 100 - it would be 1000 intervals.?

Anyone?

[kumarnatarajan]

Hi,

You can able to split the axes.

1. Go to axex Tab

2. Click your first expression to left then click second expression to right(top).

3. Then check the check the split axis.

else

You can also able to manage in scale option

[sushil353]

Hi,

You can set the scale in Axes tab of chart.

you can post the sample app..

HTH

Sushil

[#4]

That almost work - But if have two expression - It would make my first expression into one( Let me show by picture)

First expression alone:

When i then add the second expression, it takes the 4 charts and combine into one - like this:

[kumarnatarajan]

Hi,

your first exp. contain small data points. but 2nd exp. contain large data poins. So split your axis that is good one . If you want more info share your QVW file

[#6]

Here is some scramble data.

Can you show me ? I cant get it to work

[kumarnatarajan]

Hi,

It is showing currectly . you added 2 dimentions and 2 expressions so result will come depends upon your dimentions based.

You want to show all values in one view. youn should use one expression

Use this Exp:

=

if(WildMatch(DimSalesPhases.Milestone,'LOST','POC','FIRST MEETING','CONTRACT'),



count({1<DimSalesStatus.OptionID=E({1<DimSalesStatus.OptionID={'0'}>}), DimSalesPhases.OptionID=E({1<DimSalesPhases.OptionID={'-1','25','1','2','3','4','5'}>})>} PotentialCustomerKey) //Fjerne Closed og Ukendt

,

count({1<DimSalesStatus.OptionID=E({1<DimSalesStatus.OptionID={'0'}>}), DimSalesPhases.OptionID=p({1<DimSalesPhases.Milestone={'LEAD'}>})>} PotentialCustomerKey) //Fjerne Closed og Ukendt

)

But value point are not crear view. See the attached file

[#8]

I dont get this?

What you have done, you cant split the axis into breakpoints? So now you got a big jump from the buttom milestones and the big milestone leadd (just like we started)?

I need two expressions otherwise i cant break it up?