Xcelsius is a nice presentation tool to design and display dashboards. I was recently working on a the requirement of showing current time on the dashboard.At Finally I discover solution to this.
First I tried using Excel's NOW() function.The problem with now function is that it only displays the static time when you first open the dashboard. The time won't change after that even when you refresh dashboard connections.
There is a trick using History component to achieve this functionality.
>> Use now() function to populate current date and time in a cell (say A1) and format the cell to display time in HH:MM:SS format
>> In another cell (say E1) put the formula "=A1". Now E1 displays the current time as A1.
>> Drag history component (under other) on to the canvas
>> Put the formula "=E1+TIME(0,0,1)" in a cell say C1
>> Map data filed of history component to C1 and map Data Insertion field to E1 and select on interval 1 second option.
>> The E1 cell displays the current time. Map E1 cell to a text label component to display it on the dashboard.
Thursday, May 19, 2011
Subscribe to:
Posts (Atom)
