UHCARON Report post Posted February 25, 2008 (edited) 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. Edited February 27, 2008 by Guest Share this post Link to post Share on other sites
UHCARON Report post Posted February 27, 2008 (edited) 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? Edited February 27, 2008 by Guest Share this post Link to post Share on other sites
FusionCharts Support Report post Posted February 28, 2008 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. Share this post Link to post Share on other sites
