Variable in set analysis

[#1]

I have this scenario for contact centre.

We have forecast data found in an Excel spreadsheet and we gather data from our telephony system to get actual data.

I want to display in a table the forecast and the actual as the day goes by. We get actual data by 15 mins interval but when I am doing it this way the forecast is showing me for the whole day and not up to the interval for which we have actual data. I thought I could use a variable in set analysis to sum only the forecast data up to the max interval we received - something like

sum({<IntervalStart = {"<$(=vMaxInterval)"}>}Forecast)

where vMaxInterval is a variable for max(IntervalStart).

The above isn't working as expected.

Any help or advice will be appreciated.

Thanks,

Amit

[sunny_talwar]

How about this may be?

Sum({<IntervalStart = {"<$(=$(vMaxInterval))"}>}Forecast)

[#3]

That didn't work - I am still getting the forecast for the whole day.

[sunny_talwar]

How does IntervalStart look like? Is it a date field or time field? You get forecast for the whole day? It seems that you are doing < Max... so I expect that you want the whole of the period, no?

[krishnacbe]

Try Below.

sum({<IntervalStart = {"<=$(=vMaxInterval)"}>}Forecast)

[#6]

vMaxInterval is something like 03/30/2017 09:00

When I make a day selection for today 03/30 - then it should count for intervals starting from midnight to 9:00 (which is the max interval we have actual call data).

[#7]

That doesnt work as well - still giving me the full day's total forecast.

[#8]

Hi Amit,

Can you please elaborate with sample data.