Rank Function

[#1]

I have a *.qvw attached where I'm trying to rank on multiple dimensions. All I'm trying to do is literally take the Baseline chart and add another column that shows the rank (1-10). I thought this could be done by using the rank function (attempted in the "Rank Example" chart) but it's the "# Valid Consumer Submissions" by id and region instead of just ranking by the "#Valid Consumer Submissions" column. I understand why it's doing that, but I don't know how to adjust my chart so my rank is based on "# Valid Consumer Submissions".

Anyone have any thoughts?

thanks,

rob

[#2 · Accepted solution]

We were able to figure it out. We needed to have the "TOTAL" before the "sum".

rank(TOTAL sum(if(is_staff=0,IsValidSubmission,0)))

rob

[johnw]

If I understand the question, just use "total":

rank(total sum(if(is_staff=0,IsValidSubmission,0)))

[johnw]

Doh! I swear your post wasn't there when I wrote this.