Skip to main content
K
kchaithanya1-Visitor
1-Visitor
September 1, 2015
Question

How to Generate Charts In Cognos as per Date Wise

  • September 1, 2015
  • 2 replies
  • 1390 views

Hi All,

I'm using Cognos for generating reports. I've gnerated a report just like below..

cog.jpg

In the above chart, on X-axis there is an attribute called master.thePersistInfo.createStamp which represents the date of creation(as in above report list) picked from Windchill querybuilder. and ProdutGroup on PrimaryAxis .

But, there I need  a chart such that it represents date wise(i.e Date Of Ceation from the report list in above picture) product groups. i.e on x-axis different dates have to come and also primary axis should represents ProductGroup( Like Rings, Pistons.... in above picture) list with different colours.

I'm unable to generate this chartas I'm using Cognos for the first time.

I need your help to to do so.

Kindly request  to help me out.

Thanks And Regards

krishna Chaithanya

2 replies

K
kchaithanya1-VisitorAuthor
1-Visitor
September 4, 2015

Hi All,

After investigating, I've got date wise report by giving below expression for Date..

_add_days(2015-09-02,_days_between([wt.inf.library.WTLibrary=Enquiry].[MarketSegment vs DateOf Creation for August Month].[master>thePersistInfo.createStamp],2015-09-02)).

And got chart like below..

But, I  need to display  month wise Marketing segment with corresponding months and quarter wise Marketing segments with three months as a group with string names like quarter1...  When I'm trying to give _add_month expression getting validatin errors.

Kindly request to help me to achieve this as this is my high priority task.

Thanks in advance

Regards,

Krishna Chaithanya

C
ChrisPLM12-Amethyst
12-Amethyst
September 4, 2015

Hi,

I think you post may get better audience if posted in the Reporting section rather than Windchill.

Best regards

Terms & ConditionsAccessibility statement