Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Quick Question, I have a simple Expression in a line chart. I wanted to modify it so it only showed a single Work Group so that I can display all of them on a single chart. Right not my expression works, but when I try to narrow it down to one group says the expression is ok, but no data.
current:
Sum(Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)/(Count(Phone#Identifier)*100)
New:
if([Work Type]='PPA',Sum(Score0+Score2+Score1+Score3+Score4+Score5+Score6+Score7)/(Count(Phone#Identifier)*100))
I have attached a version of the report for reference.
With " its not working you need ' so you can get it to work
Strange, I created a new chart and started plugging them in, sure enough it works. Well thanks for helping me figure this one out Patrick. Much appreciated!