Finding delta.

[ASHISH2525]

Hi,

Can someone tell me How can i achieve following Results :

I need to show the delta records which mean when i click on 22 it will display 25 -22 =3 records.

The issue is here that when i use slider i wont allow me to drill down missing values.

[Sam_SAS]

Hello,

Can you give us some more details about what you want to calculate?

Do you want to calculate the difference between Sch and Act? Do you want to calculate the difference between each cell and the one above it in the table? Do you want to calculate something based on a date variable?

It is not clear how the slider control is related to your crosstab.

Finally, can you tell us which version of VA are you using?

Thanks,

Sam

[ASHISH2525]

Hi Sam,

I am using visual Analytics 7.4.

Yes i want to calculate the difference between Sch and Act & the difference between each cell and the one above it in the table.

I also want to show those records which are creating difference & these calculations are based on a date which I have used in slider. This date is basically assigning date for the record That if the record is act or sch ?


Regards,
Ashish

[Sam_SAS]

So, in 8.3 we have a operator called AggregateCells that might do what you want with regard to each cell and the one above it.

Calculating the difference between Sch and Act everywhere is easy if you do something like Abs(Sch - Act). Assuming you want it to be the absolute value?

From what I understand, the dates shouldn't be involved in your calculated item because they are acting as a filter.

[ASHISH2525]

Exactly agree with you that date slider actually acting as filter.
If somewhere date is missing for sch or act then slider doesn't allow to include that. Is there anywork around to overcome this ?

[Sam_SAS]

Are you saying that you can't assign a date variable to a slider if the date variable contains missing values?

I don't have a good data set handy to test this, but I could try to create one if you can confirm that is the issue.

[ASHISH2525]

No. I can assign but I meant to say that suppose a sch or act contains it's date as missing then those records with missing date do not appear in cross tab I interact cross tab with slider.

[Sam_SAS]

Ahh! I see. For the objects that are filtered by the date slider, you don't see any values where the date is missing.

I'm not sure how to work around this, unfortunately.

Do you have the other part of your question resolved, calculating the difference between act and sch?