This is the table that I have. What I am trying to do is have a trellis by Batch and create Rank on the fly and use Norm_Rank as the dimension.
=aggr(rank(sum(Value),1,1),Batch) gives me duplicate values in Rank
=aggr(rank(sum(Value),1,1),[Sub Batch]) gives me rank of the total population (1 to 15)
Can you help me get the rank as shown in the table.
I have attached the sample qvw. I was able to get the calculated dimension working using the below
I have few other issues now
1) I want to show the avg of values as a line for each Batch separately.
Avg(Total <Batch> Value) - This expression gives the same number as Value instead of gettting the average of all the values per Batch.
2) I want to show the (avg + std dev) of values as a line for each Batch
avg(total<Batch> Value)+stdev(total<Batch> Value) - This expression gives a single number for all the values across the batches.
I am stumped.
Hi there! I tried this within my model, and it shows always from rank #2 and below, but #1 is never displayed. Any clue? I assumed because the nulls, but when apply nulls, they don't have the #1.