Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to apply the color on the actual bar in the chart based on the budget value.
if the actual is greater than or equal to budget value, than the color of the actual bar is in green else its in red.
I tried the expression, but its not working while using two dimensions.
kindly help me to resolve this issue.
thanks in advance.
thanks,
Gopinthan
I think you can remove the dimension Trx_Flag and get the color
Hi there.
Try this expression for the background color and delete the field Trx_Flag from the dimensions.
if
(
sum
(
{$<Trx_Flag={'Budget'}>}
Expression1_Budget
)
<=
sum
(
{$<Trx_Flag={'Actual'}>}
Expression1
),
Red(),Green()
)
is that?
Hi,
Thanks for all your reply.
Please find the attachment, which shows the reason of the dimension required in the bar chart.
Thanks in advance.
Hi Enrique,
I think this one is working. But I am not able to figure out changes you did.
If you don't mind, can you please explain me?
Thanks,
Aakash
Yes, this are the changes
Hi,
Thanks for all your support.
Finally I got the solution, here with i attached the document FYR.
! !