showing incorrect count

[arulsettu]

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

[tamilarasu]

Hi,

[arulsettu]

thanks for the reply guys

i am using cyclic group. four dimension in that.

and i need to show this in bar chart.

so plz suggest some idea for this

[tamilarasu]

Count expression

Count({<BW_MAKE_DESC= {"=Rank(Count(BW_MAKE_DESC))<=10"}>}BW_VEH_ID)

Percentage expression

Num(Count({<BW_MAKE_DESC= {"=Rank(Count(BW_MAKE_DESC))<=10"}>}BW_VEH_ID) / Count({<BW_MAKE_DESC= {"=Rank(Count(BW_MAKE_DESC))<=10"}>}TOTAL <BW_VEH_ID> BW_VEH_ID), '#,##0%')

[awhitfield]

You have the same BW_VEH_ID associated with multiple BW_MAKE_DESC

Andy

[arulsettu]

yes multiple vech for single make

[MK_QSL]

Have you tried my solution?

[arulsettu]

yes manish bro. but i am using cyclic group..

[MK_QSL]

That's why it is always better to provide proper sample file... If you need this expression for Cyclic Group, you should have provided an example with cyclic group rather than what you have supplied. This will save time from both sides... your and those who are replying !

If you can provide better example... ! We would work on this.

[t_chetirbok]

you can try to create two chart that showing comparison current and total value. something like this:

[arulsettu]

here is the sample with cyclic group