6 Replies Latest reply: Jun 22, 2011 7:36 AM by Anne Duffy

# Missing data between 2 charts Puzzle

Hi Guys

I have 2 tree maps,

One is based on the demensions   Activity = 'Customer Service'

Type of Query

Expression is [Type of Query ] = calculation is if(Activity='Customer Service',sum(Number))

This works perfectly,

The 2nd Tree map was Cloned from this one and basically it is looking at cycle times,

Demensions are the same,

based on the demensions   Activity = 'Customer Service'

Type of Query

Expression is [Time to complete ] = calculation is if(Activity='Customer Service',sum(Number)*[Time to complete])/60

This also works perfectly, at least it was , I have noticed that one activity in particular is not reporting correctly, on the first Chart it is numerical value of 13,610 ( which is correct) I would expect to see it on the second chart with a value of 58, its is not.

Now in saying that this QV doc is pulled from numerous Excel sheets and this particular field is only common the 3 particular Areas, once I drill into those areas on the list box function the correct data comes up. But without the drill down it is not calculated as part of the total.

Can anyone help ?

Thanks

A

I only have a personal edition QV license so not sure I can post a sample

• ###### Missing data between 2 charts Puzzle

I don't think it's so easy to identify this problem with the description.

We may not be able to send you a solution, but you can share a sample with the community.

• ###### Re: Missing data between 2 charts Puzzle

Hi Erich

See attached ( Ive made a sample ), the query is on Auto Confirmations,

When nothing is selected in list box Customer service has 1088 Auto Confimations, we would expect Customer Service to have 4.71 ( which is 1088 mulitplied by 26 divided by 60)

It has nothing.

If I select Mark and then BBI for Branch it displays correctly as 4.71 , Do you know why it wouldnt be accounting that 4.71 as part of the total unless the selections have occured ?

Thanks

• ###### Re: Missing data between 2 charts Puzzle

Hi,

Here is an example, Have a look at this.

Regards,

Kaushik Solanki

• ###### Re: Missing data between 2 charts Puzzle

Hey Kaushik,

I still only have personal edition ( Awaiting licenses and stuff) Any chance you'd be able to talk me through any discrepencies you have found please ?

Thanks

• ###### Re: Missing data between 2 charts Puzzle

Hi,

Remove the calculated dimension from both chart.

Use below expression in respective charts.

=(sum({\$<Activity = {"*Customer Service*"}>}Number)*sum({\$<Activity = {"*Customer Service*"}>}distinct [Time to complete]))/60

=sum({\$<Activity = {"*Customer Service*"}>}Number)

Regards,

Kaushik Solanki

• ###### Re: Missing data between 2 charts Puzzle

Thanks Kaushik

Works perfect

A