COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: MikoMan on 30 Oct 2016 05:09:17 AM

Title: Total for group of items
Post by: MikoMan on 30 Oct 2016 05:09:17 AM
Hi ,

I have a report which divided into 2 parts.
Part 1, show a graph for a week duration for group if interface data usage.
All the interfaces are stacked on each other and gives the graph attached here.

Part2 , I need to create a second chart which will be for a long duration, for example a month.
This chart will only needs to show the total of the interfaces and not all of them stacked.
Simple chart with one line for a month.

How do i calculate it and create this chart.

Thanks,

Miko
Title: Re: Total for group of items
Post by: BigChris on 31 Oct 2016 03:41:27 AM
Create a second query for your second graph. Filter it according to the time period you need and only include the data that you want in the graph.