there are answers for your objectives
1) When there is a reference value (i.e. Average Call Duration is 6 mins) for a destination then this would be alerted visually.
Yes this is possible. You can colour code the visualizations to display RAG for quick insights of the data. You can even visualize the data you have in any intuitive way you can imagine off.
2) The above point would need to be across a set of variables (i.e Service Level or Product Level, Answer Seizure Ratio,etc)
Yes this can be achieved.
3 & 4) The data would be set up to be held for 24 hours at any one given time.Data update would need to be updated automatically.
for automatic data refresh from your sources you will have to go with the enterprise version of Qliksense. The entire process can be automated.
Where would this formula be set? (i.e. Dimension) of a chart?
Is there are many destination with variable KPI, do you know any way the above can be defined to specific destination(s)?
Also the ranking of the destination(s), can this be ordered automatically by the criteria (i.e. Minutes, No of Calls,etc).