How to implement an expiration date in an Xcelisus dashboard?

How to implement an expiration date in an Xcelisus dashboard? – MyXcelsius.Com div.cute_profiles_sprite{top:275px;left:0px;}//#smooth_sldr{width:550px;height:180px;background-color:#7f6d57;border:2px solid #4f4131;}#smooth_sldr_items{padding:10px 12px 0px 12px;}#smooth_sliderc{width:526px;height:125px;}.smooth_slideri{width:526px;height:125px;}.sldr_title{font-family:Trebuchet MS, Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;font-style:normal;color:#ff991b;}#smooth_sldr_body h2{line-height:23px;font-family:Calibri, Arial, Helvetica, sans-serif;font-size:20px;font-weight:normal;font-style:normal;color:#f0f0f0;margin:10px 0 5px 0;}#smooth_sldr_body h2 a{color:#f0f0f0;}#smooth_sldr_body span{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;font-weight:normal;font-style:normal;color:#ffffff;}.smooth_slider_thumbnail{float:left;margin:10px 5px 0 0px;border:2px solid #4f4131;}#smooth_sldr_body p.more a{color:#f0f0f0;font-family:Verdana, Arial, Helvetica, sans-serif;font-size:12px;}#smooth_sliderc_nav li{border:1px solid #ffffff;font-size:12px;font-family:Verdana, Arial, Helvetica, sans-serif;}#smooth_sliderc_nav li a{color:#f0f0f0;}.sldrlink{padding-right:25px;}.sldrlink a{color:#ffffff;}MyXcelsius.ComVisual Data Analysis, Information Dashboards and Related Technologies

Skip to Content ?HomeShowcaseVideosVideos from SAPContactAuthorsArchivesHow to implement an expiration date in an Xcelisus dashboard?Sep 23rd, 2010

by Greg Wayne. TweetShareEmailTweetShareEmail

Here is an Xcelsius/Excel trick that allows you, the developer, to set a validity period on a dashboard. This is great for sharing demos or giving a potential client an evaluation period.

1. Setup your Excel file as follows

Cell B1 enter your start dateCell B2 enter the Now() function to determine the current dateCell B3 use the Date() function to capture the year, month, and day. Then add the number of days that you want to make the dashboard viewableCell B4 use an IF() statement to compare the expiration date to the current date

2. Here you can get creative, however for this example I am going to keep it simple. Add a background component to the canvas and make sure it takes up the entire workspace.

3. Set the dynamic visibility of the background component to cell B4 and set the key as “expired”. Be sure to check the “Block mouse movements” found on the “General” tab of background properties.

4. Top your dashboard off with a pop-up box or watermark displaying how many days remaining in the evaluation period by taking the difference of cells B3 and B1.

There you have it, a simple solution to implementing a validity period within your dashboards.

Please feel free to download the sample Excel file

If you enjoyed this post, make sure you subscribe to my RSS feed!No TweetBacks yet. (Be the first to Tweet this post)