Hello,
I would like to show the following in a diagramm:
For every question asked, we have the date of asking the question and the date of Answering it.
I would like to have a scatter plot (when that is what it is called. I mean a point in the diagramm for every question) or any other diagramm that visualises those two dates for every question raised.
If I just put those pair of dates in two colums of a table and export this to excel, it makes a perfect scatter plot out of it.
In cognos the diagramm tells me, that the y-axis cannot have a date as a value.
If I would have a second wish free, I would also like the following:
on the axis there should be a "complete calendar". By that I mean the following:
when I put in the many dates of questions asked, now the diagramm only makes room for every input-date. That means, that when we have many questions in january, none in february and then again some in march, the first question in march would be directly next to the last question in january. Idealy the whole year would be spread out on the axis, every day of the year becomes equally much room, regardless of wether there were none, one or many questions. With more then one question asked on a certain day it would just mean, that there are more points above each other (depending on when we answer them).
Hope this makes sense to you and someone could answer these questions
regards
------------------------------
Ludwig Leijten
------------------------------
#CognosAnalyticswithWatson