Clarity PPM

Expand all | Collapse all

Issue with Timescaled Portlets

Jump to Best Answer
  • 1.  Issue with Timescaled Portlets

    Posted 10 days ago
    ​I am trying to create a timescaled portlet where the cost (actual, forecast,budget) needs to be displayed in three lines.

    cost type    Jan20    Feb20  Mar20
    -----------------------------------------------
    Actual       100        100       100
    Forecast   200         200      200
    Budget      300        300      300

    From my query, I am getting the attributes (Actual, Forecast, Budget) as columns for all the months.
    Please let me know how to create the portlet in the above mentioned format.

    Regards,
    Arunima


  • 2.  RE: Issue with Timescaled Portlets

    Posted 10 days ago
    I don't think we can build custom timescaled portlets based upon NSQL queries (only on stock data-providers with a timescaled element).

    If this is a NSQL based query then building one with multiple dimensions might be the answer (data would still display in separate columns though).

    Or just write the NSQL such that it delivers the data in a grid (as per your layout example) - three UNION'd statements could deliver the 3 distinct rows in your example.


  • 3.  RE: Issue with Timescaled Portlets

    Posted 10 days ago
    Hi David,

    Thank you for the reply. I am using multiple dimensions portlet and also using union in the query but still the output is in columns.

    Regards,
    Arunima


  • 4.  RE: Issue with Timescaled Portlets

    Posted 10 days ago
    There is some discussion on that in
    https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=4864a697-5b52-4275-928f-b2c1603c8d47&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer#bm4864a697-5b52-4275-928f-b2c1603c8d47


  • 5.  RE: Issue with Timescaled Portlets

    Posted 7 days ago
    "I am using multiple dimensions portlet and also using union in the query but still the output is in columns."

    Yes - and as I said you will always have that ; I don't think "timescaled" can be produced via NSQL as it relies on built-in tiimescaled data providers.

    You can definitely produce output that looks like your example, but it will all be in rows/columns (just a grid of data).



  • 6.  RE: Issue with Timescaled Portlets
    Best Answer

    Posted 7 days ago
    Agreed with my skilled colleague.

    Looking quickly at i, it could be something like

    Sub query for actuals (Subsubquery for Month 1, Subsubquery for Month 2, Subsubquery for Month 3
    Union
    Sub query for forecast (Subsubquery for Month 1, Subsubquery for Month 2, Subsubquery for Month 3
    Union
    Sub query for budget (Subsubquery for Month 1, Subsubquery for Month 2, Subsubquery for Month 3