Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Excluding Categories with no value in Dashboard Visualization

    Posted 02/27/20 03:56 PM
    ​Hello - I have an organization table with thousands of entries. When I use it in a Visualization and then apply a measure, there are many more rows without values for that measure than with. Is there a way to indicate rows without values should be filtered out?
    I'm using CA 11.0.13 and an XLS "data module" as the source.
    Thanks for your assistance.

    ------------------------------
    Regards,
    Opher
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Excluding Categories with no value in Dashboard Visualization

    Posted 02/28/20 04:07 AM
    Filter your measure in the visualisation, and set interval 0 to 0, and then invert

    ------------------------------
    Sandeep Dhirad
    ------------------------------