Cognos Analytics

Expand all | Collapse all

Dashboards: Remove empty columns and/or rows from visualizations

  • 1.  Dashboards: Remove empty columns and/or rows from visualizations

    Posted Thu July 18, 2019 05:58 AM
    Is there a way to remove columns and or rows that don't have any values from visualizations in a Dashboard?
    Filtering a Measure to only show values of a certain range only works when all values are above or below zero.

    I'm running IBM Cognos Analytics 11.1 R1


    ------------------------------
    Huginn Ragnarsson
    ------------------------------


  • 2.  RE: Dashboards: Remove empty columns and/or rows from visualizations

    Posted Thu July 18, 2019 10:24 AM
    That sounds like zero suppression. I've looked in a visualisation and I can't see anything that would give you that. Could your filter exclude where the measure <> 0?

    ------------------------------
    Chris Turner
    ------------------------------



  • 3.  RE: Dashboards: Remove empty columns and/or rows from visualizations

    Posted Fri July 19, 2019 09:20 AM
    Yeah I'm basically asking about zero suppression in Dashboards.

    The filter for the measures is only a slider so I don't have the option to exclude 0.

    ------------------------------
    Huginn Ragnarsson
    ------------------------------



  • 4.  RE: Dashboards: Remove empty columns and/or rows from visualizations

    Posted Fri July 19, 2019 10:02 AM
    Hi Huginn,

    You should be able to type "0" for both start and end values, then hit "Invert", effectively selecting "everything except 0-0"


    ------------------------------
    LAURA ALKHOURY
    ------------------------------



  • 5.  RE: Dashboards: Remove empty columns and/or rows from visualizations

    Posted Fri July 19, 2019 12:39 PM
    That is a good suggestion but works only if the visualization has just one measure as doing this will filter out lines where other measures have values.

    ------------------------------
    Huginn Ragnarsson
    ------------------------------