line chart with common x-axis for two expressions

[ali_hijazi]

hello

got the followng sample data

Defect ID        Fix Period              Defect Period

1                      1                            0.5

2                      1                            1

3                      2                             1.25

...

I need to have a line chart with x-axis having values that range between 1 and 12

the chart need to show two types of lines one showing the number defects by Fix period and the other by defect period both on the common axis

is this doable?

[Anonymous]

Hi Ali,

Your x-axis is represented by which field in your table?

Antoine

[ali_hijazi]

here is the difficulty

I want same axis for two expressions

[Anonymous]

Ali,

Still, which will you use as an x axis? Defect ID? Fix Period? Defect Period?

What are you trying to represent? You could attach a picture...

Cheers,

Antoine

[#5]

Is this what are you looking for ?

PFA

[jonathandienst]

Hi

Create an data island for your dimension:

MonthIsland:

LOAD RowNo() As isMonths AutoGenerate 12;

Now use:

     = Count(Distinct If(Round([Fix Period]) = isMonths, [Defect ID])   

     = Count(Distinct If(Round([Defect  Period]) = isMonths, [Defect ID])

for your expressions.

HTH

Jonathan

PS: you could use ValueList but I prefer to create the dimension as shown above

[ali_hijazi]

if I want to use ValueList

then round([Fix Period]) will be compared to which value?

please advise

[ali_hijazi]

but still I need the line to show at 0.5, and 1.25 for defect period

please advise