I have a content type with the following date fields:

1. Start Date
2. Deadline Date
3. End Date

Deadline date is programmatically calculated, where as Start and End are based on user input.

There is a page with a table view for open nodes, ones without an End Date. In it, I would like to have a graphical representation of nodes alongside a graphical representation of time left from now until End Date.

I made a chart block view with serials as labels and dates as data, but the only result I got was a flat line with 0. Then tried every format combination listed under the date field without any luck. Although that, post date as a field seems to return correct results(?).

For a specific node Devel listed the following:

created (String, 10 characters ) 1451882207

field_end_date (Array, 1 element)
    und (Array, 1 element)
    $...->field_end_date['und']
        0 (Array, 4 elements)
            value (String, 19 characters ) 2016-10-27 00:00:00
            timezone (String, 11 characters ) Asia/Riyadh
            timezone_db (String, 11 characters ) Asia/Riyadh
            date_type (String, 8 characters ) datetime

Creating timestamp fields gave the same flat line. So, I am unsure about what the exact issue is. Help would be appreciated on how to reach the desired outcome or about how to debug this if it is not a feature.

Charts 7.x-2.x-dev

I have a content type with the following date fields:

1. Start Date
2. Deadline Date
3. End Date

Deadline date is programmatically calculated, where as Start and End are based on user input.

There is a page with a table view for open nodes, ones without an End Date. In it, I would like to have a graphical representation of nodes alongside a graphical representation of time left from now until End Date.

I made a chart block view with serials as labels and dates as data, but the only result I got was a flat line with 0. Then tried every format combination listed under the date field without any luck. Although that, post date as a field seems to return correct results(?).

For a specific node Devel listed the following:

created (String, 10 characters ) 1451882207

field_end_date (Array, 1 element)
    und (Array, 1 element)
    $...->field_end_date['und']
        0 (Array, 4 elements)
            value (String, 19 characters ) 2016-10-27 00:00:00
            timezone (String, 11 characters ) Asia/Riyadh
            timezone_db (String, 11 characters ) Asia/Riyadh
            date_type (String, 8 characters ) datetime

Creating timestamp fields gave the same flat line. So, I am unsure about what the exact issue is. Help would be appreciated on how to reach the desired outcome or about how to debug this if it is not a feature.

I'm using Charts version 7.x-2.x-dev.