count columns of data in access database
FusionCharts Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



count columns of data in access database Expand / Collapse
Author
Message
Posted 2/25/2008 9:53:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 2/28/2008 12:21:45 PM
Posts: 2, Visits: 6
Hi,

Oops, I meant counting rows of data. I've got an access database that has 7 columns and over 45,000 rows of data.  I'm trying to figure out how to use fusion charts to work like a pivot chart in excel.  I think I'd use the data url method.... becuase I want the xml generated from the countif query.  I want to count the number of values that meet a particular filter/query.  For instance, I want to count the number of sytems that transferred files per month.  Then I want to drill down per system for a particular month.  Then I want to see the type of file per system transferred per day.  Lastly, I would want to see historical monthly views of my systems so I can see trends.  My data base has all the necessary columns of data to function as a pivot chart, but now I want to present this on the web.  My access database also has all the tables i.e. months, days, systems, types.  The guides for this application don't present this kind of info. 


   
Post #4704
Posted 2/27/2008 11:41:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 2/28/2008 12:21:45 PM
Posts: 2, Visits: 6
So, I'm reading this forum... Fusion Gadgets v3 can perform a drill down and do a data get / dynamic data query at the second level, correct?  So if I wanted to simulate a pivot table from thousands of data rows, then I would need to use Fusion Gadgets?
Post #4748
Posted 2/28/2008 12:24:50 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Moderators
Last Login: Today @ 1:31:05 AM
Posts: 677, Visits: 1,081
hi,

Almost all charts and gedgets and maps can perform Drilldown. You ca ngo through our online Demos from where you can definitely get an idea. Out Blueprint demo almost match your specifications.

http://www.fusioncharts.com/Demos/Blueprint/

http://www.fusioncharts.com/gadgets/Demos/Blueprint/

http://www.fusioncharts.com/maps/Demos/AJAX/Index.html

You can download them from our download pages.

Regards,

Sudipto Choudhury
FusionCharts Team

Post #4759
« Prev Topic | Next Topic »


Permissions Expand / Collapse

All times are GMT -7:00, Time now is 6:44am


Execution: 0.063.