Cognos Analytics

 View Only
Expand all | Collapse all

Combination Chart and Line Chart

Diego Jose Urbaneja Pacheco

Diego Jose Urbaneja PachecoMon April 06, 2020 03:51 PM

#CognosAnalyticswithWatson
Diego Jose Urbaneja Pacheco

Diego Jose Urbaneja PachecoMon April 06, 2020 04:59 PM

#CognosAnalyticswithWatson
Diego Jose Urbaneja Pacheco

Diego Jose Urbaneja PachecoTue April 07, 2020 09:08 AM

#CognosAnalyticswithWatson

  • 1.  Combination Chart and Line Chart

    Posted Wed March 25, 2020 10:39 AM
    I am trying to make a line graph in which a data that accumulates over time must be displayed, for that I use running-total (field). For example accumulated monthly sales, when I press tabular data from the query to see if it does it well and effectively, but when it is displayed in the graph it is not shown as a continuous line. Has anyone had that problem? I am using Cognos Analytics 11.1 R3 and the type of chart I am using is Line. This is a report made in a previous version for which a Combination Chart was used where it works but now it has been decided to change the type of the chart.

    Tabular data inside query:



    Chart Line: Doesn't work… Cognos A. 11.1 R3



    Like this, Combination Chart old version


    Any comments?

    thanks in advanced






    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Combination Chart and Line Chart

    Posted Thu April 02, 2020 09:22 AM
    Hi Diego

    Just tried to build something similar and I can't see what you are seeing... it's producing the chart I would expect, from a running total..
    Please share your report spec so I can see and reproduce what you have....

    Torben



    ------------------------------
    Torben Noer
    ------------------------------

    Original Message


  • 3.  RE: Combination Chart and Line Chart

    Posted Mon April 06, 2020 03:51 PM
    Edited by System Test Fri January 20, 2023 04:38 PM

    #CognosAnalyticswithWatson


  • 4.  RE: Combination Chart and Line Chart

    Posted Mon April 06, 2020 04:12 PM
    Edited by System Test Fri January 20, 2023 04:33 PM
    Hi Torben, I appreciate your support:


    There are two years, current and previous and the chart should be like this:


    Where each line is one year, like I said previously, current and last year. And for every year show months.




    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    Original Message


  • 5.  RE: Combination Chart and Line Chart

    Posted Mon April 06, 2020 04:59 PM
    Edited by System Test Fri January 20, 2023 04:11 PM

    #CognosAnalyticswithWatson


  • 6.  RE: Combination Chart and Line Chart

    Posted Tue April 07, 2020 03:42 AM
    Edited by System Test Fri January 20, 2023 04:31 PM

    Hi Diego

    I can't see what you have included...  the report spec is probably too large for the box to include... so you would need to link to it instead or attach it as a file (using the upload functionality below this box)

    Torben



    ------------------------------
    Torben Noer
    ------------------------------

    Original Message


  • 7.  RE: Combination Chart and Line Chart

    Posted Tue April 07, 2020 09:08 AM
    Edited by System Test Fri January 20, 2023 04:11 PM

    #CognosAnalyticswithWatson


  • 8.  RE: Combination Chart and Line Chart

    Posted Tue April 07, 2020 12:11 PM
      |   view attached
    Hi Torben, here I attached the report definition.

    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    Attachment(s)

    xml
    ReporteEventosPerd.xml   168 KB 1 version
    Original Message


  • 9.  RE: Combination Chart and Line Chart

    Posted Tue April 14, 2020 07:48 AM
      |   view attached
    Hi again...

    Looking at your report, I assume it's the "Evolución mensual de pérdidas" on the second tab? But I don't see any "running total" defined for the 2 measure used in that chart? So I would assume you are not calculating the running total? I can see you are calculating it in other charts, but not for a chart with 2 measures.
    The best thing here would be to reduce the report, down to 1 list and 1 chart so you can see what's going on... like I did in the attached report. Then it's easy to see if it's calculating the running total correctly. 

    Torben


    ------------------------------
    Torben Noer
    ------------------------------

    Attachment(s)

    txt
    AR with running total.txt   5 KB 1 version
    Original Message


  • 10.  RE: Combination Chart and Line Chart

    Posted Tue April 14, 2020 10:53 AM

    Thank a lot Torben, once again.

    You are right, I fixed that. My new issue is that I need to show the values in each point, but this chart doesn't have a property "Show Values", so I'm trying using IBM Vizualization Customizer for that issuing this:

     

    "label":[{

                  "content":["Value: ",{"$ref":"metricField"}],

                  "style":{

                     "fill":"blue",

           "font":{"size":11},

                     "location":"outside",

                     "valign":"end"

                  }

    }]

     

    But it doesn't work yet…




    Thanks in advance.



    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    Original Message


  • 11.  RE: Combination Chart and Line Chart

    Posted Tue April 14, 2020 08:34 PM
    Problem Solved.

    I have just downloaded a visualization from Visualization Samples All Cognos Analytics 11 and could modify some attributes.


    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    Original Message


  • 12.  RE: Combination Chart and Line Chart

    Posted Wed April 15, 2020 03:49 AM
    Sounds good!

    For Active Reports you need to use the 11.0 visualizations... but for all other reports you should move to 11.1 visualizations... and from 11.1.4 you can also use the custom visualizations where you can customize everything in visualizations by using external libraries like D3 or HighChart/GoogleCharts etc...  more on this also when we launch the Accelerator Catalogue very soon....

    ------------------------------
    Torben Noer
    ------------------------------

    Original Message


  • 13.  RE: Combination Chart and Line Chart

    Posted Wed April 15, 2020 03:37 PM
    How are you supposed to make use of the visualizations in the zip file?

    ------------------------------
    jerome roberts
    ------------------------------

    Original Message


  • 14.  RE: Combination Chart and Line Chart

    Posted Fri April 17, 2020 11:12 AM
    Hi, Joreme.

    You can use IBM® Cognos® Visualization Customizer to open the zip file and then,  proceed to customizing: change colors, titles and others properties.  When you finish that, you go to Cognos Analytics/Manage/Administration Console/Library/import visualization.






    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    Original Message


  • 15.  RE: Combination Chart and Line Chart

    Posted Fri April 17, 2020 12:41 PM

    Thanks for your reply.  I still don't understand.  We have IBM Cognos Analytics 11.1 R4.  Aren't the visualization already in the tool? 

     




    Original Message


  • 16.  RE: Combination Chart and Line Chart

    Posted Fri April 17, 2020 02:46 PM
    Actually the tool is not part of  IBM Cognos Analytics,  look at this link https://www.youtube.com/watch?v=GgQLdiHJ5yI and you can see how to use the tool to customizing   your chart.




    ------------------------------
    Diego Jose Urbaneja Pacheco
    ------------------------------

    Original Message


  • 17.  RE: Combination Chart and Line Chart

    Posted Mon April 20, 2020 02:32 AM
    Hi Jerome

    This Rave customizer is for the older visualizations in Cognos Analytics.... From 11.1 you should only use the "11.1 Visualizations" and since you are using 11.1 R4, you can use the custom visualizations part of Cognos Analytics where you can import D3, Google Charts, HighCharts etc into Cognos Analytics. We will also very soon launch an Accelerator Catalog with more samples of visualizations not already inside Cognos Analytics. You can also customize those further if you want.
    https://community.ibm.com/community/user/businessanalytics/blogs/ian-oeschger/2019/10/31/your-data-your-visuals-custom-visualizations-with

    ------------------------------
    Torben Noer
    ------------------------------

    Original Message


  • 18.  RE: Combination Chart and Line Chart

    Posted Mon April 20, 2020 10:27 AM

    Aha!  Understand now.  Thanks for the clarification and heads-up on future augmentations.

     




    Original Message