I need to create a chart based on date data that are inconsistent. In other words, the dates on which the data were collected aren’t on a normal interval - somtimes it was every day for a week, then a week would be skipped, then the following week, it was only two days, etc.
What I’d like to do is turn these data into a chart that - for lack of a better word - extrapolates the missing dates. I want the axis where the dates appear to have a contant interval instead of the inconsistent interval I get when I make a simple chart from my table. The data points only need to appear on the dates where actual data were collected; I don’t want to extrapolate these, just the dates to make the interval constant.
Anyone have any ideas? I wasn’t able to find any obvious setting in the chart format dialog to do it.
We just finished creating something that does the same thing. In the database, we created a new table that contains dates for every day of the year, then linked the two tables together in BO. This way, we were able to fill in the missing dates from the new table. It works quite well.
Michael Welter
Sr. Technical Analyst
AirTouch
I need to create a chart based on date data that are inconsistent. In other words, the dates on which the data were collected aren’t on a normal interval - somtimes it was every day for a week, then a week would be skipped, then the following week, it was only two days, etc.
What I’d like to do is turn these data into a chart that - for lack of a better word - extrapolates the missing dates. I want the axis where the dates appear to have a contant interval instead of the inconsistent interval I get when I make a simple chart from my table. The data points only need to appear on the dates where actual data were collected; I don’t want to extrapolate these, just the dates to make the interval constant.
I was hoping to do it in Reporter rather than change the database - I did think of simply populating the table with dummy dates with no data as well.
Thanks for the tip.
Paul
Michael Welter wrote:
We just finished creating something that does the same thing. In the
database,
we created a new table that contains dates for every day of the year, then linked the two tables together in BO. This way, we were able to fill in
the
missing dates from the new table. It works quite well.
Hi Listers,
This one is about chart formatting.
The situation is I have a Line chart indicating Last Year and This Year’s Data. Also the chart shows data label values.
Since the Last year and This Year values are close the overlap. Is there a way to format the Data Label Values in such a way that they appear without Over Lapping.