close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Chart date axis

Thread began 4/07/2010 3:26 pm by bretherine396470 | Last modified 4/09/2010 2:28 pm by Eric Mittman | 900 views | 2 replies |

bretherine396470

Chart date axis

Hi, I am using dynamic charrts to display product orders against date. However I cannot seem to get the date to run oldest to most recent on the x-axis. It just seems to wrap around; e.g. 28, 30, 31, 24, 25, 26, 27? Any ideas? Also, is there a way to stop it from missing out dates that have a value of zero? since it gives a distorted look if you want to see how something changes with date.

Regards

Sign in to reply to this post

bretherine396470

I've also noticed that creating charts based on different date groupings, e.g. by day, week and month do not match, i.e. total of all days in march, does not match the value for march in the 'group by month' version of the same chart.

I currently have my date mysql data in a "date + time" format; could this be the problem?

Sorting by date seems to make no difference, and when I re-enter the wizard this sorting info is lost (i have DWC version 1.04).

Any assistance you can provide would be gratefully received as i really need to get this sorted.

Regards,

Sign in to reply to this post

Eric Mittman

Rather than grouping by the date you should try to just order by the date. This should give you all of the dates in order. If there is a record that has a date it will be listed and the value for that date plotted on the chart.

As for the sorting options being lost you can check on the data page inside of the DynamicWebCharts folder in your site. You should be able to see the grouping and order in here.

If you have any further trouble with this please post back and include a copy of the db in a sql file and the page and DynamicWebCharts folder. I can check it out for you to see what is going on.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...