Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I've created a barchart using a measure for its colors.
It works well.
I would like to display units too, in the color legend and in the measure (displayed when the mouse is over a bar).
I've tried using Num(measure), Money(measure) (as the unit is a monetary unit), and even Dual(), but these functions have no effect.
For example, with Dual():
=Dual( Avg( Aggr(Sum({<OLC_PipelineStatus={"Closed Won"} , OLC_Status={'C03_Closed'} , TotalVsWeighted={'Total amount'} >} OLC_AmountPerProduct), OLC_OpportunityNumber, OLC_DateSnapshot) ) &' k€' , Avg( Aggr(Sum({<OLC_PipelineStatus={"Closed Won"} , OLC_Status={'C03_Closed'} , TotalVsWeighted={'Total amount'} >} OLC_AmountPerProduct), OLC_OpportunityNumber, OLC_DateSnapshot) ) )
The unit never appears.
Is there a way to display units with color scales?
@Patrik_Lundblad - thoughts?
There isn't any method that I can think. Thanks for highlighting this!
Regards,
Patrik.