Another option to consider for addressing these requirements is the Forena module.

You would use it's report writing features (such as its WYSIWYG report writer and/or it's query builder) to first create a report that fits your needs. The result of it could be a tabular output and/or graph. After the report content matches the specifications, you could save it as (e.g.) a CSV or XML file. Did I mention it also comes with some interesting hooks?

Refer to Reasons for considering Forena to understand why I think it might be a good fit, especially because of this part in it:

... if you want to do aggregation or analytics, Forena is much more suited to address these requirements."

The Forena Video demos and tutorials contain quite some links to live demos.

Disclosure: I'm a co-maintainer of this module,
I hope this does not violate the site's policy on self-promotion.

Another option to consider for addressing these requirements is the Forena module.

You would use it's report writing features (such as its WYSIWYG report writer and/or it's query builder) to first create a report that fits your needs. The result of it could be a tabular output and/or graph. After the report content matches the specifications, you could save it as (e.g.) a CSV or XML file. Did I mention it also comes with some interesting hooks?

Refer to Reasons for considering Forena to understand why I think it might be a good fit, especially because of this part in it:

... if you want to do aggregation or analytics, Forena is much more suited to address these requirements."

The Forena Video demos and tutorials contain quite some links to live demos.

Disclosure: I'm a co-maintainer of this module,
I hope this does not violate the site's policy on self-promotion.

Another option to consider for addressing these requirements is the Forena module.

You would use it's report writing features (such as its WYSIWYG report writer and/or it's query builder) to first create a report that fits your needs. The result of it could be a tabular output and/or graph. After the report content matches the specifications, you could save it as (e.g.) a CSV or XML file. Did I mention it also comes with some interesting hooks?

Refer to Reasons for considering Forena to understand why I think it might be a good fit, especially because of this part in it:

... if you want to do aggregation or analytics, Forena is much more suited to address these requirements."

The Forena Video demos and tutorials contain quite some links to live demos.

Be Aware: I am a co-maintainer of Forena ...

Another option to consider for addressing these requirements is the Forena module.

You would use it's report writing features (such as its WYSIWYG report writer and/or it's query builder) to first create a report that fits your needs. The result of it could be a tabular output and/or graph. After the report content matches the specifications, you could save it as (e.g.) a CSV or XML file. Did I mention it also comes with some interesting hooks?

Refer to Reasons for considering Forena to understand why I think it might be a good fit, especially because of this part in it:

... if you want to do aggregation or analytics, Forena is much more suited to address these requirements."

The Forena Video demos and tutorials contain quite some links to live demos.

Disclosure: I'm a co-maintainer of this module,
I hope this does not violate the site's policy on self-promotion.