Different results with and without a Variable

[george55]

Hi all,

Have two questions.

1. When putting a formula in a variable and use the variable in the app (e.g. in a chart) and on the other hand use the same formula directly in the app, the results is different. Don't understand why.

The correct numbers are like this below (putting the formular directly in the chart-app):

When going with the variable, all numbers are the same:

This is the formular:

1-(
(
Sum(Aggr(Count(Distinct {<[X_CAL.Calldirection]={'Inbound'}>} [%CallId]), [X_EVE.HuntGroup], [X_CAL.TimeStamp.Calendar.Year], [X_CAL.TimeStamp.Calendar.Quartal], [X_CAL.TimeStamp.Calendar.Month], [X_CAL.TimeStamp.Calendar.Week], [X_CAL.TimeStamp.Calendar.Day]))
-
Sum(Aggr(Count(Distinct {<[X_CAL.Calldirection]={'Inbound'}, [X_EVE.EventType]={'TALKING'}>} [%CallId]), [X_EVE.HuntGroup], [X_CAL.TimeStamp.Calendar.Year], [X_CAL.TimeStamp.Calendar.Quartal], [X_CAL.TimeStamp.Calendar.Month], [X_CAL.TimeStamp.Calendar.Week], [X_CAL.TimeStamp.Calendar.Day]))
-
Sum(Aggr(Count(Distinct {<[X_CAL.Calldirection]={'Inbound'}, [X_EVE.EventType]={'28'}>} [%CallId]), [X_EVE.HuntGroup], [X_CAL.TimeStamp.Calendar.Year], [X_CAL.TimeStamp.Calendar.Quartal], [X_CAL.TimeStamp.Calendar.Month], [X_CAL.TimeStamp.Calendar.Week], [X_CAL.TimeStamp.Calendar.Day]))
)
/
Sum(Aggr(Count(Distinct {<[X_CAL.Calldirection]={'Inbound'}>} [%CallId]), [X_EVE.HuntGroup], [X_CAL.TimeStamp.Calendar.Year], [X_CAL.TimeStamp.Calendar.Quartal], [X_CAL.TimeStamp.Calendar.Month], [X_CAL.TimeStamp.Calendar.Week], [X_CAL.TimeStamp.Calendar.Day]))
)

2. and my second question:

is there a way to shorten all the time-dimensions?
[X_CAL.TimeStamp.Calendar.Year], [X_CAL.TimeStamp.Calendar.Quartal], [X_CAL.TimeStamp.Calendar.Month], [X_CAL.TimeStamp.Calendar.Week], [X_CAL.TimeStamp.Calendar.Day]

Have a period master-item, but don't know if it is possible to use it within a expression. so maybe I can avoid writing all the time dimensions many times.

thank you for your inputs and help.

[george55]

Great Rob!

This was exactly what I was looking for. Thank you.

George