Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Plz refer to attachment.
I want to find out query % month on month.
e.g. In this example, in 1st column, I want to find Count of "Duplicate" type query. This I got.
In 2nd column, I want total no. of "Duplicate" type query. In 2nd column, against each month, in front of "Duplicate", there should be same no. as 7 (sum of "Duplicate" queries across all months).
I tried with Count and Aggr function as
Textcount(Aggr(Textcount(QueryType),QueryType))
What is wrong here?
Thanks.
If I understand you right (and I'm not sure I do) you don't need Aggr() - try:
TextCount(TOTAL <QueryType> Query)
Hope this helps,
Jason
If I understand you right (and I'm not sure I do) you don't need Aggr() - try:
TextCount(TOTAL <QueryType> Query)
Hope this helps,
Jason
hi
i didnt realy understood what you want to do but first you need to change the expression
Textcount(Aggr(Textcount(QueryType),QueryType)) to
sum(Aggr(Textcount(QueryType),QueryType)) as the inner textcount returns numbers you need to use sum in your expression
Dear Liron,
As per your suggestion, I rectified expression.
Still there is problem.
Please refer to attachment (where I applied your expression). I have written in Blue text boxes what output should occur instead of zeroes.
I hope this clarifies my query.
Please help.
Thanks.
Dear Jason,
This works perfect.
Thanks a lot.
Cool. Please close the thread by marking a correct answer.
Jason