If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to create a line chart in ReportStudio with %'s to Total

Started by Fiala, 30 Apr 2008 03:39:45 PM

Previous topic - Next topic

Fiala

Does "ANYONE" know how to create a line chart in Cognos Report Studio for the following:
Objective:
Compare Current Year & Previous Year % of Payments to Total Revenue based on payment types. (refer to attached example)

I have tried everything I can to create this line chart.  I've researched numerous sources but have not been successful.  One would think this would be a no brainer but................. 
It seems the %'s are not used as examples in all the research I've done, does this mean there's a problem?

Any help would be greatly APPRECIATED!


almeids

Seems pretty straightforward, what problem(s) are you having?

Fiala

I simple want to compare Claims paid to Total Revenue by year & month.

When I use the Cognos line chart (see attachment .jpg) I simply can't just use the Total Revenue as my Y Axis and the Claims Paid by year as my Series.  However, when I add the Total Revenue to the Series my results look good with the exception of the Total Revenue shows as a line on the graph as 100% (refer to attached .jpg.  If it didn't display the Total Revenue as a series it would work for me.

Any suggestions?

almeids

Sharon, I apologize if I'm being dense, but why can't you remove Total Revenue?  Just because it's in your query doesn't mean it has to be on the report, unless something's drastically changed in C8.

Fiala

This specific line chart selected uses the "last" series as the 100% to compare the Claims Paid.  Now perhaps I'm making this harder than necessary.  There are only 2 line charts that compare % measures to a total.

I agree, this should not be difficult.  If you look at my previous attachment of the OBJECTIVE chart (from Excel) is the format needed.  However, the charts available for % to total ADD the Total Measure to the chart as a line item (because it's in the series but even the chart selection image shows it at the top of the chart).  I simply want a % to Total.  Y axis1 should be the Total Revenue and the series should be Claims Paid by year.

I must be missing something.  None of the chart selections seem to lend a % to total in the format that we require.

???

almeids

I see.  "Revenue as Y axis" doesn't click for me since what you want is a percentage...but it looks like that's the way this sort of Chart works.
How about using a generic line chart and calculating the percentages yourself in the query?  That's what I thought you were doing originally and I think will give you what you want.

Fiala

I believe I tried that but I tried soooooo many different things.  I try that again.
Thanks for all your help!

blom0344

Graphs in C8 are less straightforward then they were in ReportNet, but I believe that using just one Y-axis for both percentages and an amount (total revenue) is one step to far..

Fiala