Dimension interval

[ali_hijazi]

hello

I have two expressions on a line chart

on the x-axis I want to show values that range from 0 till 12

How can I attain this?

Please advise

[#2]

can you tell us what your x axis expression is?

[ashfaq_haseeb]

Hi Ali,

Use below as calculated dimension.

=ValueLoop(1,12)

Regards

ASHFAQ

[ali_hijazi]

well I'm working on a Quality Control system where defects have a fix period (fix date - release date in number of months), and a defect period (defect date - release date in number of months)

my expressions will count the number of defects but the first need to draw the count group by fix period and the other expression needs to draw the line that show the count group by defect period

[ali_hijazi]

let's say my expression is count(defects)

I want to show two lines one by how many months it took to be fixed after release date and the other by how many months the defect was created after the release date

and the number of months is the x axis that ranges from 1 till 12

[ashfaq_haseeb]

Hi Ali, In this case create a field in back-end as below

num(month(YourDate)) as Month_Num.

Create a chart by selecting

Month_Num as dimension, make sure you selected show all values and suppress when value is null.

then write your two expressions.

Hopefully should solve your issue.

If it does not help try by sharing app.

Regards

ASHFAQ

[ali_hijazi]

no the x axis shall show the number of months after the release date not the month number

[#8]

Hi Ali, If you want create the Dimensional Interval, You the Class function. But Class function is not fit to ur requirement.

Please post some sample data

[ali_hijazi]

i know the class function will classifiy result into ranges on the x-axis

[#10]

=ValueList(1,2,3,4,5,6,7,8,9,10,11,12)