Chart - No measure

[cognos_users]

Please pour in your suggestions:

There are 10 valuable customers to a campany. Each of them work with different branches of the same company. As time passed some of them shifted to other branches of the same company to purchase goods. How do I show these changes in graphical way in report studio report. I tried scatter plot etc but since there is no exact measure for my request, it isn't working.

Customer  Branch  Date
A             B1       1/1/1990
A             B2       5/1/2010
B             B1       2/3/1995
B             B3       6/8/2010

I need to capture these transitions and show them in some graphical way. Which type of chart will work?

[cognos_users]

Any suggestions???

[Lynn]

Try adding a data item to your query that you can use as a measure. A count expression of some sort.

Then you can play around with various charting options. Which aspect of the change you are trying to illustrate can affect which chart is best. Line graphs are good for change over time. A series of pie charts might be good if you wanted to see how many of these customers each branch had at various times. Maybe a stacked bar chart if you want to look at each customer's time spent at the various branches.

The possibilities go on and on. It might help if you define the business questions to be answered. Having only a fixed date in time may not lend itself to some charting options.