Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master III

showing incorrect count

hi i am doing simple count

count(id) and for ratio count(id)/count(total id)

count(total Id) is incorrect.

in straight table i checked.in properties expression tab if i use Expression as total it showing correct.

how to do this bar chart.

Note: i am using cyclic group in dimension

37 Replies
arulsettu
Master III
Master III
Author

i need to include max year in this. can some one suggest

MK_QSL
MVP
MVP

You want to have only TOP 10 or for all?

arulsettu
Master III
Master III
Author

Tatsiana Chetirbok‌ just now noticed you included BW_MAKE_DESC but i am using cyclic group.check below i uploaded sample. plus i need to include max year

arulsettu
Master III
Master III
Author

top 10 only bro

Anonymous
Not applicable

But..... there was no cyclic group in the sample qvw you provided.

To avoid confusion, it is always best to provide a sample that reflects properly what you have / are trying to do.

Anonymous
Not applicable

This thread has got really confused and is already marked as correctly answered.

I'd suggest you start a new thread for your new question.

MK_QSL
MVP
MVP

Let me know if this is not what you want !

Ignore red lines in Expressions ... It's a bug !

t_chetirbok
Creator III
Creator III

Hello!

I attached my example. I am sure that expression can be more efficiency, but it only that I have done for now.