PostalGirl Report post Posted March 4, 2012 I have a heatmap on a coldfusion page that uses data supplied by an SQL database. Some of the columns are numbers, some are text, and some are time values. The numbers and text values display just fine, but the time values do not. In the sql database, the time fields are stored as: 1899-12-30 21:30:00.000 I need them to display on the heatmap as HH:MM time only: 21:30 I have the color-coding working perectly based on being before or after a specified time (red is bad, green is good)...but the values themselves do not display. Currently my code is: value='#query.LastOGP#' But I have also tried: value='Timeformat(#query.LstOGP#)' but it makes no difference. How can I get the time values to appear on the heatmap? Share this post Link to post Share on other sites
Guest Sumedh Report post Posted March 5, 2012 Hi, It will be helpful for us, if you post your XML code which you have generated for the HeatMap chart. And also, send us the screen shot of your chart which you are currently rendering. Awaiting your response. Share this post Link to post Share on other sites
PostalGirl Report post Posted March 7, 2012 Thank you for the offer of assistance Sumedh...but crisis averted today. I modified my query to give me the time field twice...one as time type (so I can perform calculations on it), and again converted to char type so I can have displayvalue on the heatmap with just the hh:mm. It is working great! I absolutely LOVE FusionCharts!! Share this post Link to post Share on other sites
Guest Sumedh Report post Posted March 7, 2012 Hi, I am glad that you have managed to resolve your issue. Happy FusionCharting ! Share this post Link to post Share on other sites
