creating secondary line chart

[kumarkp412]

Hi  Friends,

I am facing problem to creating the two dimensional line chart. i am having three fields (start date ,end date and id)

i want to calculate the two dimensional  line chart based on two date (i.e to in one chart to show the start date as one line and end date as another line ) based  on this date i want to calculate count of ids

so i am using two expression to get the count

when i am taking the two date Fields in dimension, it is taking one dimension  and other dimension it is ignoring and i am getting the two line of same value .

Can any one help me.

Thanks in advance,

[MK_QSL]

Temp:

Load ID, StartDate, EndDate From TableName;

LinkTable:

Load ID, StartDate as Date, 'START' as Flag Resident Temp;

Load ID, EndDate as Date, 'END' as Flag Resident Temp;

Now create a Line Chart

Dimension

Date

Expression

COUNT({<Flag = {'START'}>}DISTINCT ID)

COUNT({<Flag = {'END'}>}DISTINCT ID)

[buzzy996]

can u try this,

one "start date" dimension with y-axis1 ans end date  with y-axis 2 by changing the POSITON(right to top) of dimension from Axes tab.

[kumarkp412]

Hi Manish,

Thanks for reply,

I tried this what you send, but it was giving the different values,

Thanks

Kumar

[kumarkp412]

Hi Shiva ,

I also tried the position (right to top) in axes tab ,but it is not giving the correct value.By using that it will divide the axes two axes.

Thanks

Kumar

[MK_QSL]

Provide Sample Data please

[kumarkp412]

Hi Manish ,

I have made some little changes in the script you tried ,Then it is coming correctly

Thanks

Kuamr