I have attached a detailed description of my question in the document. I am looking for an option where I can map multiple datapoint labels in order to show respective cost values on each column in the graph portlet. Any suggestions on this, please?
Not sure I am understanding the question correctly, but your portlet (NSQL based?) should deliver a metric that is just "cost" and then broken down by BU and then planned or budget.
(rather than what it is doing now which is providing a break down by BU and showing the budget cost and the planned cost)
I think! (GUESSing a lot here)
My portlet is NSQL based clustered column portlet to show total planned cost vs budgeted cost. I am good with the portlet output, however, if you see the attachment there are values(metric costs) on each column. I would like to show them as currency in $. I feel that is something to do Datapoint label configuration in portlet configuration. As this is a clustered column graph, how do I apply label for each column(one column with planned cost$ and another column with budget cost$) Please refer to the attachment in the initial post.
I am looking for something like below but with respective dollar values.
Don't think you can introduce the currency symbol into the datapoint if you are displaying a number (have you tried returning the "cost" as a MONEY datatype rather than a number?)
Alternatively you could construct a string value in your NSQL - a "display value" and build the "$1,593,075" as a string and use that display-value as the datapoint label.
I have created a string value for the budget cost and another for planned cost, but there is an option only to map only one datapoint label, and I was trying to find how to map if there are multiple columns as in my scenario.
On the other note, We are with oracle db. May I know how can we return money attribute using nsql.
I'm still a little confused by what your NSQL delivers;
I am imagining it returning 'rows' like this;
BusinessUnit / Budget Cost / Actual Cost
BU1 / 3071961 / 2080238
BU2 / 3850150 / 2848421
BU3 / 101603981 / 34651833
My original comment was trying to say that I think it needs to return rows like this;
BusinessUnit / Cost Type / Cost
BU1 / Budget / 3071961
BU1 / Actual / 2080238
BU2 / Budget / 3850150
BU2 / Actual / 2848421
BU3 / Budget / 101603981
BU3 / Actual / 34651833
(But even now I'm not sure that is right - perhaps you just need your two cost types set up as different METRICS in the NSQL and then you can plot them independently)
My comment about MONEY datatype was just coming from the documentation, specifically HERE where it says;
MONEY (<currency column>) specifies that the value is a monetary amount. The column alias in parentheses specifies the currency. The currency must also be part of the SELECT statement.
under the Data Types section.
(I don't think I have ever experimented with that myself though, sorry)
Currently, my resultset looks like
I will try modifying in another way. Thanks for your suggestions.
Retrieving data ...