Author Topic: Grouping By Parameter on Combination Chart  (Read 244 times)

Offline emerson_parker

  • Associate
  • **
  • Join Date: Jun 2021
  • Posts: 3
  • Forum Citizenship: +0/-0
Grouping By Parameter on Combination Chart
« on: 10 Jun 2021 01:53:26 pm »
Greetings! Totally new to Cognos Analytics, working my way through my first report.

I've got a Combination Chart that's showing a value. I've got a parameter for company division (multiselect).

What I Want It To Do: When I select more than one company division, add a new line to the combination chart.

What It Does: Sums the values of the company divisions.

Please help?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,329
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
Re: Grouping By Parameter on Combination Chart
« Reply #1 on: 11 Jun 2021 08:56:17 am »
Greetings! Totally new to Cognos Analytics, working my way through my first report.

I've got a Combination Chart that's showing a value. I've got a parameter for company division (multiselect).

What I Want It To Do: When I select more than one company division, add a new line to the combination chart.

What It Does: Sums the values of the company divisions.

Please help?

Hi,

What data items are you currently using for the columns and the lines? There is a dropdown just above the drop targets for the fields in the visualization - you can switch between Column and Line. Have you tried using the company division item as the data item that drives the line color chart?

Cheers!

MF.
Meep!

Offline emerson_parker

  • Associate
  • **
  • Join Date: Jun 2021
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Grouping By Parameter on Combination Chart
« Reply #2 on: 22 Jun 2021 12:23:24 pm »
Hi,

What data items are you currently using for the columns and the lines? There is a dropdown just above the drop targets for the fields in the visualization - you can switch between Column and Line. Have you tried using the company division item as the data item that drives the line color chart?

Cheers!

MF.

Categories (x-axis): My date dimension
Series (primary axis): My "rate" fact

The data is accurate when I'm only showing one department parameter. But when I have two department parameters checked, it doesn't give me two lines. Thoughts?

Please and thank you.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,329
  • Forum Citizenship: +665/-10
  • Cognos Software Muppet
Re: Grouping By Parameter on Combination Chart
« Reply #3 on: 22 Jun 2021 02:05:46 pm »
Categories (x-axis): My date dimension
Series (primary axis): My "rate" fact

The data is accurate when I'm only showing one department parameter. But when I have two department parameters checked, it doesn't give me two lines. Thoughts?

Please and thank you.

I'm guessing these are in the Columns dialog of the visualization? What do you have defined in the Lines dialog?

MF.
Meep!

Offline emerson_parker

  • Associate
  • **
  • Join Date: Jun 2021
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Grouping By Parameter on Combination Chart
« Reply #4 on: 22 Jun 2021 02:56:07 pm »
I'm guessing these are in the Columns dialog of the visualization? What do you have defined in the Lines dialog?

MF.

Ah, there are three things. That'll do me. I'm getting errors now, but that's progress. Thank you!