Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How about this may be?
Sum({<IntervalStart = {"<$(=$(vMaxInterval))"}>}Forecast)
That didn't work - I am still getting the forecast for the whole day.
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?
Try Below.
sum({<IntervalStart = {"<=$(=vMaxInterval)"}>}Forecast)
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).
That doesnt work as well - still giving me the full day's total forecast.
Hi Amit,
Can you please elaborate with sample data.