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

 

Count of Different # of Cars Sold Per Year Per Stacked on Stacked Chart

Started by HelloCognos, 26 Jul 2018 07:28:27 AM

Previous topic - Next topic

HelloCognos

Hi, :) :)

I need to create the Data Items in a Query that is related to a 100% Staked Chart in Cognos. One Stack needs
to show the car sold for 2016 and others need to show for 2017, 2018, etc. Once I have the Data Items, I can drop it in the
Series Primary Axis with the Measure as the Total Cars Sold and the X-AXIS showing the Year/Month.

So in order to create the Data Item, let me know what you suggest based on using if then else or case statement for
the three Data Item to show in the 100 Staked Chart. See attachment.

Thanks in advance for your time

sdf

are you looking for percentage of total?
have you the total sales for each year?

HelloCognos

Just a # of sales per each year so the data item will result to the # of sales for 2017 and another data item will show the # of sales for 2018.
I guess it would be the total sales for 2017 and total sales for 2018 so I can drop them on top of the Measure showing all sales and x-axis showing
each month and year.

Lynn

Quote from: HelloCognos on 26 Jul 2018 10:33:41 AM
Just a # of sales per each year so the data item will result to the # of sales for 2017 and another data item will show the # of sales for 2018.
I guess it would be the total sales for 2017 and total sales for 2018 so I can drop them on top of the Measure showing all sales and x-axis showing
each month and year.

I'm not sure I understand the requirement. If you have month and year on the X-Axis then you are only going to show sales for the corresponding month and year in any particular bar. Having separate metrics to bucket sales by year won't make sales appear anywhere other than the year that corresponds to each x-axis item. Or am I missing something?

If you want to compare sales for each month across years, you can put month only (not year) on the x-axis, sales as your measure, and year as your series. It will automatically break out sales by year so you don't need to compute anything special to break out sales by year.

Of course I might be completely missing the point here. Attached is a report spec of what I've described in case it is helpful.

HelloCognos

Well, it is my ignorance regarding to the Dashboards and Charting since this client asks for so much of Visualization stuff.

Thanks so much Lynn! yes, this is what I was looking for.  :) :)

HelloCognos

Any quick way of grouping the 2015 and 2016 cases together in one dataitem or show them together in a BAR?