chart problem

[arulsettu]

hi i created a chart. and i added this code to

=class(floor((Today()-BirthDate)/365.25),$(agerange),'Age')

calculated dimension.

expression is sum(sales).

i created a slider and added a variable agerange.

but the result is nothing like this

i need to display like this

[arulsettu]

here i attached my app in customers tab check the chart

any one can help? thanks...

[maxgro]

in your database you have

the table HR_Employee with ContactID and BirthDate

the table OrderHeader with ContactID and TotalDue

but the ContactID with TotalDue hasn't the BirthDate (they are missing in HR_Employee)

and the ContactID with BirthDate doesn't have TotalDue (they are missing in OrderHeader)

first put in place your db

second it seems to me you're using the variable agerange in calculated dimension but the variable is missing

[arulsettu]

hi Massimo

i have created variable agerange. hoe can i display the data any idea ? thanks...

[MK_QSL]

Dear Arul,

I have created a straight table for BirthDate and SUM(TotalOverDue)... There is no relation between both of them.

BirthDate	SUM(TotalDue)
	$140707584.82
	$140707584.82

[maxgro]

something is wrong in the data of your db

the ContactID of OrderHeader should be also present in HumanResource_Employee table

for now they are missing

I can't fix your source data (access db?)

Are you sure in access db you use as sourcedata,

the ContactID of HumanResource_Employee

are the ContactID of OrderHeader?

I don't think. Try to check this first in Access.

[maxgro]

yes probably the ContactID are different in access db (the source)

[arulsettu]

hi

contact id in HumanResource_Employee table

and contact id sales_orderheader table are linked. and its all in same database... i can see the relation in table viwer

[arulsettu]

hi

i think contact id in both tables are linked... am i correct?

[maxgro]

the are linked (correct)

but they always have different ContactID (problem; from the access db I presume)

if you create a chart like this and two listbox BirthDate and SalesOrderID you can find the problem

ContactID with TotalDue and without BirthDate

ContactID with BirthDate and without TotalDue