Planning Analytics

 View Only
  • 1.  Problems to zero supression using a calculated field

    Posted Mon November 26, 2018 01:26 PM
    Hi there!

    I'm facing a problem to supress zero in a calculated column, please look the example:
    Zero SupressionThe column 'Hrs 1º T" is a calculation, created in Paw. In this case i'm using the columns "1ºT" and "Aj. 1º T" to create the column "Hrs 1º T".

    Does anyone here have already saw it? Thanks in advanced!

    ------------------------------
    Marcelo Rodrigues
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Problems to zero supression using a calculated field

    Posted Wed May 01, 2019 08:49 AM
    Hi Marcelo,

    Thanks for your question.

    It is my experience as well that calculations "created" in PAW (where resultant value is "zero") -- do not get suppressed (either on row or column).

    I'd recommend you creating this variance in the form of a new measure line-item, if your intention is to have the entire row / column disappear on activating suppressing.

    Hope this helps!

    Cheers,
    Roscoe

    ------------------------------
    Roscoe Lobo
    Leader - Data Science & AI
    Veracitiz
    India
    ------------------------------



  • 3.  RE: Problems to zero supression using a calculated field

    Posted Wed May 01, 2019 09:35 AM
    There are few videos related to PAW
    1. Workbook design - Design Templates
      YouTube remove preview
      Design Templates
      Table of Contents: 00:06 - Concept of Design Templates 02:01 - KPI Model Example 02:48 - Create a Design Template This Video demonstrates the concept of design templates, shows a finished product and walks through how to build one from scratch.
      View this on YouTube >
    2.  Maps - IBM Planning Analytics Tips & Tricks: Display Data in Maps
      Revelwood Knowledge Center remove preview
      IBM Planning Analytics Tips & Tricks: Display Data in Maps
      Did you know you can easily visualize data with IBM Planning Analytics Workspace? IBM Planning Analytics Workspace (PAW) allows you to visualize your data using a variety of charts and graphs, including the ability to display your results via a map. The only requirement for mapping is to ensure that your geography dimension includes recognizable place names.
      View this on Revelwood Knowledge Center >
    3. Sandbox comparison on Planning Analytics Workspace
      Octanesolutions remove preview
      Sandbox comparison on Planning Analytics Workspace
      Sandbox, also known as Personal Workspace is your personal work area where you can edit the data values as many times as you want and keep the changed data separate from the base data. Sandboxes and Personal Workspaces are private to each user and cannot be seen by other users.
      View this on Octanesolutions >


    ------------------------------
    paul YOUNG
    ------------------------------