Questions regarding chart

---

Couple of questions regarding chart:

1. To create a chart with series added from JSON. Added a JSON loader and provided the path(See sampleData-realreactive.json) and the Raw JSON(See rawJSONProp.png) got populated. Output Table property is not populated with any data. How should I proceed with adding the series?

2. I have a datepicker, which is bound to Date Range to one of the series added through dynamic properties(table for multiple axis). I would like to update the date range automatically to always choose the date range between yesterday and tomorrow. How to achieve this functionality?

Attachment: download link

These are both tricky questions to answer in a forum post, I think it would be something I'd need to look at live on your system.

Joel.

Attached is an updated json loader widget that will work for you. Simply point the path to your json file and click update and then you'll see your data in the table. To update copy this file over the old one in MA_HOME/web/modules/dglux/web/packs/DataProviders

I'm also attaching an updated dglux.swf file which will upgrade to version 11638. This should add a relative option on the date picker that might help in your date range needs. To upgrade over write the file in MA_HOME/web/modules/dglux/web/core with this new one. For both of these upgrades you'll have to clear your browsers cache and refresh.

Hope that helps,

Joel.

Attachment: download link

Here's a script that should meet your needs, storing the dateRange string of the form yyyy/mm/ddT00:00:00-yyyy/mm/ddT23:59:59

var currDate = new Date();
var date = currDate.getDate();
var month = currDate.getMonth() + 1; //turns out months are 0 indexed
var year = currDate.getFullYear();

if(month == 12 && date == 31) {
dateRange = "" + year + "/12/30T00:00:00-" + (year+1) + "/1/1T23:59:59";
}
else if(month == 1 && date == 1){
dateRange = "" + (year-1) + "/12/31T00:00:00-" + (year) + "/1/1T23:59:59";
}

else if(day == 31) {
dateRange = "" + year + "/" + month + "/" + (date-1) + "T00:00:00-" + year + "/" + (month+1) + "/1T23:59:59";
}

else if(day == 30 && (month == 4 || month == 6 || month == 9 || month == 11)) {
dateRange = "" + year + "/" + month + "/" + (date-1) + "T00:00:00-" + year + "/" + (month+1) + "/1T23:59:59";
}

else if(month == 2 && day == 28) {
if(year % 4 == 0 && year % 100 != 0) {
dateRange = "" + year + "/" + month + "/" + (date-1) + "T00:00:00-" + year + "/" + (month) + "/29T23:59:59";
}
else {
dateRange = "" + year + "/" + month + "/" + (date-1) + "T00:00:00-" + year + "/" + (month+1) + "/1T23:59:59";
}
}

else if(day == 1) {
if(month == 2 || month == 4 || month == 6 || month == 9 || month == 11) {
dateRange = "" + year + "/" + (month-1) + "/31T00:00:00-" + year + "/" + (month) + "/2T23:59:59";
}
else if(month == 3) {
if(year % 4 == 0 && year % 100 != 0) {
dateRange = "" + year + "/2/29T00:00:00-" + year + "/" + (month) + "/2T23:59:59";
}
else {
dateRange = "" + year + "/2/28T00:00:00-" + year + "/" + (month) + "/2T23:59:59";
}
}
else {
dateRange = "" + year + "/" + (month-1) + "/30T00:00:00-" + year + "/" + (month) + "/2T23:59:59";
}
}

else {
dateRange = "" + year + "/" + month + "/" + (date-1) + "T00:00:00-" + year + "/" + month + "/" + (date+1) + "T23:59:59";
}

You could also do it with a lot more long term flexibility via:

var currDate = new Date();
var pastDate = new Date(currDate.getTime() - (6060241000));
var futureDate = new Date(currDate.getTime() + (6060241000));

dateRange = "" + pastDate.getFullYear() + "/" + (pastDate.getMonth()+1) + "/" + pastDate.getDate() + "T" + pastDate.getHours() + ":" + pastDate.getMinutes() + ":" + pastDate.getSeconds() + "-" + futureDate.getFullYear() + "/" + (futureDate.getMonth()+1) + "/" + futureDate.getDate() + "T" + futureDate.getHours() + ":" + futureDate.getMinutes() + ":" + futureDate.getSeconds();

In a perfect world we could say:
dateRange = pastDate.toISOString() + "-" + futureDate.toISOString()
but alas the Date objects in DGLux don't have the .toISOString method, apparently.

I have discovered that for certain internal usages you have to have leading zeros for the hours, minutes, and seconds fields. It can cause interesting results, otherwise.