Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
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
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%')
You have the same BW_VEH_ID associated with multiple BW_MAKE_DESC
Andy
yes multiple vech for single make
Have you tried my solution?
yes manish bro. but i am using cyclic group..
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.
you can try to create two chart that showing comparison current and total value. something like this:
here is the sample with cyclic group