Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a stacked bar chart with the below expression.
count(DISTINCT{<DateType={'Created'},Ticket_Type=>}[TR #])+
count(DISTINCT{<DateType={'Created_IN'},Ticket_Type=>}[Incident Number])+
count(DISTINCT{<DateType={'Created_RTC'},Ticket_Type=>}Id)
This is independent of the list box selection Ticket_Type.
I have defined the below in the background colour in the chart
if(Priority = '1.High', RGB(255,0,0),
if(Priority = '2.Medium-High', RGB(255,128,64),
if(Priority = '3.Medium-Other',RGB(245,217,47),
if(Priority = '4.System / Job Failures', RGB(102,194,150),
if(Priority = '5.Low BPS', RGB(77,167,65))
)
)
)
)
But when I make a selection in the Ticket_Type in the listbox the colours change. Can anybody please help me how to make the script used in the background colours independent of the field Ticket_Type?
Hi Sanjyot,
Please try:
if(only({1}Priority) = '1.High', RGB(255,0,0),
if(only({1}Priority) = '2.Medium-High', RGB(255,128,64),
if(only({1}Priority) = '3.Medium-Other',RGB(245,217,47),
if(only({1}Priority) = '4.System / Job Failures', RGB(102,194,150),
if(only({1}Priority) = '5.Low BPS', RGB(77,167,65))
)
)
)
)
Hi,
Can you upload sample qvw or else what is your other expression and whether the other expression also has backround color property.
Hi Sanjyot,
Please try:
if(only({1}Priority) = '1.High', RGB(255,0,0),
if(only({1}Priority) = '2.Medium-High', RGB(255,128,64),
if(only({1}Priority) = '3.Medium-Other',RGB(245,217,47),
if(only({1}Priority) = '4.System / Job Failures', RGB(102,194,150),
if(only({1}Priority) = '5.Low BPS', RGB(77,167,65))
)
)
)
)
thanks..It worked