I'd like to create a time series of values. A kind of a matrix, with dates on the horizontal axis (i.e. 2011-01-01, 2011-02-16, 2012-04-05 as column headers) and keys as row headers. Values of each row represent a single measure changing over time.
The number of columns should be dynamic, ranging from 1 to 5. This number can be fetched before fetching the actual values if needed. I have created a scripted data source, so the format of the data set can be whatever suits birt best.
How can I achieve this with birt 3.7? I tried to adapt from
http://digiassn.blogspot.com/2007/11/birt-dynamic-adding-tables-and-columns.html but without success.