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
Original Message:
Sent: 02-17-2020 03:43 AM
From: David Morton
Subject: Issue with Timescaled Portlets
"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).
Original Message:
Sent: 02-14-2020 01:12 PM
From: Arunima Roy
Subject: Issue with Timescaled Portlets
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
Original Message:
Sent: 02-14-2020 08:58 AM
From: David Morton
Subject: Issue with Timescaled Portlets
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.
Original Message:
Sent: 02-14-2020 08:08 AM
From: Arunima Roy
Subject: Issue with Timescaled Portlets
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