solutions help: I am in a great mood this morning/tonight! - Help.com

I am in a great mood this morning/tonight!

I have been struggling with a problem for months and I just suddenly had a huge breakthough! I have been trying to build a website that utilized a Chart API by programmatically writing up the image links based on data pulled off of a database. There were so many frustrating things to overcome and today the part that had been stumping me for so long finally fell into place!

My scripts compensate for the temporal gaps between data entries by interpolating the missing information and now finally I have managed to overcome the problems posed by null values in columns created in large tables in which may not have information recorded on the same day as other columns.

It all clicked into place in a very short period of time, there has been a host of problems with this endeavour have been nagging me for months… now they are vanquished! Shadows of passing memories happily forgotten. When I got it all to work right it was one of those smack yourself in the forehead moments! Once one problem was solved the rest fell like dominoes. The human mind is strange… we can be stumped for a long time and the bang! In the immortal words of the ancient Greek scholar Archimedes… Eureka!!

This open post was written 11 months, 1 week ago | V/U/S: 152, 5, 2 | Edit Post | Leave a reply | Report Post


Reciprocity (0) Reciprocation Failure -- The poster has NOT helped anyone else yet!

Since writing this post PureLogix may have helped people, but has not within the last 4 days. PureLogix is a verified member, has been around for 1 year, 3 months and has 8 posts and 280 replies to their name.

Post Tags (3)

Replies (5)

Where were you?

Click and drag to move the map around. FAQ: How we place people on this map »
You can also watch events on Help.com as they happen
Mouse over the map for 2 seconds to see an expanded, interactive view

chunkymove offline Verified User (1 year, 2 months) Long Term User Shouts: 19 #
An Unknown Location | 11 months, 1 week ago (7 minutes after post)

as douglas adams said “grab a towel”.

when you say interpolate, do you mean average from the values either side?

Quote this reply Report this reply to moderators
PureLogix offline Verified User (1 year, 3 months) Long Term User Shouts: 1 #
An Unknown Location | 11 months, 1 week ago (12 minutes after post)

yeah, but it the number of values being solved were always differnt.

Like if there was data for the 15th of the month but there was not another entry until the 20th and then the next time was on the 30th.

It figures out the missing information by creating virtual data that is non-existent. So you have to deal with variable temporal gaps plus a whole bunch of other things that make it difficult. Its quirky stuff.

Quote this reply Report this reply to moderators
chunkymove offline Verified User (1 year, 2 months) Long Term User Shouts: 19 #
An Unknown Location | 11 months, 1 week ago (13 minutes after post)

and you were trying to display it graphically along side months taht had data for every day?

Quote this reply Report this reply to moderators
PureLogix offline Verified User (1 year, 3 months) Long Term User Shouts: 1 #
An Unknown Location | 11 months, 1 week ago (17 minutes after post)

Not quite. There are several independent catagories that you may not nececarily have information for but the way the database is designed each user gets their own tables that contain the potential to record information in all of the catagories. It simplifies the whole ordeal… I think having 6 to 100+ tables per user is just crazy and multiplies the work.

Some may have info while others don’t and some may have none at all. Its all good now though.

Quote this reply Report this reply to moderators
PureLogix offline Verified User (1 year, 3 months) Long Term User Shouts: 1 #
An Unknown Location | 11 months, 1 week ago (19 minutes after post)

A guy could use the site for a few years and even with amalgamated tables each table would still be pretty small in size.

Quote this reply Report this reply to moderators

Invite Others to Help

A logged in and verified Help.com member has the ability to setup a Friends List and invite others to help with posts.