My Last Tweet: San Diego
If you need the current time in a dashboard, the Excel formula is NOW() is useful for many scenarios. If the local PC time is not adequate I found a slick Yahoo web service that will provide me with a single XML node with current time: http://developer.yahoo.com/util/timeservice/V1/getTime.html 1. First I used XML Maps in Excel [...]
Dynamic Formatting in Xcelsius Tables
10/28/2008 by 32 Comments
Xcelsius’ Excel paradigm for binding data inherits Excel’s absence of dynamic cell formatting. In Excel, you define a cell format as text, percentage, value, date, etc… When you bind a component to a cell or range, it will automatically inherit the formatting. If your hoal is to filter data by measures, you may have found [...]
Xcelsius Formulas: Calculating Current Quarter
08/22/2007 by Leave a Comment
Many times, you want your dashboard to query data based on the current quarter, month, day or year. Within Xcelsius you can easily calculate these values. The trickiest part is calculating the quarter since that is not a natively supported function. Download Source Files First you will declare the current date using the function: NOW(). [...]
Calendar Date Formatting in Xcelsius
04/09/2007 by Leave a Comment
Written by: Ryan Goodman Published: April 9th, 2007 3352 views Posted in Excel Logic, Xcelsius If you are working with dates within a connected Xcelsius dashboard, you can run into potential issues related to formatting. In most cases, you will require a specific format when you want to pass a date as a parameter to a web service. [...]
Dynamic Excel Lookup Logic for Xcelsius
03/28/2007 by 2 Comments
Here is a scenario that many people have…. You have a connected model and the web service returns tabular data, but Xcelsius does not have the ability to lookup multiple rows of data with their selectors. Unfortunately, with Xcelsius 4.5 you have to rely on some Excel skills to assemble a layer of logic that [...]
