All - Hoping experts here can help me in getting the custom tooltip right
I have a single series Stacked Vertical Bar chart (Image below) and I want the tooltip to be as below rather than whats on the screenshot below:
Category: EQ TEC DE INF
NBV: 17996580.52 (If possible formatted to show like currency formatting - 999G999G999G999G990D00)
Assets: <Asset_Count> which is on the Y axis
The region source SQL query is
SELECT AGEING_BUCKET,
ASSET\_TYPE,
COUNT(DISTINCT SERIAL\_NUMBER) ASSET\_COUNT,
SUM(NBV) NBV
FROM
(
SELECT DISTINCT AGEING_BUCKET,
ASSET\_TYPE,
IB\_SERIAL\_NUMBER SERIAL\_NUMBER,
FA\_BOOK.CORP\_COST - FA\_BOOK.CORP\_ACC\_DEPRN NBV
FROM XXEC_OKL_211_RMKT_ASR_RET_V ASR,
XXEC\_OKL\_211\_RMKT\_AST\_FA\_FIN\_V FA\_BOOK
WHERE AGEING_BUCKET <> 'NA'
AND ASR.ASSET_ID = FA_BOOK.ASSET_ID
)
GROUP BY AGEING_BUCKET,
ASSET\_TYPE
Data returned currently is:
