topic Re: Top N chart is showing N-1 value in App Development

Top N chart is showing N-1 value

Devendra_Babar — Sat, 16 Nov 2024 20:51:21 GMT

Hello Everyone,

I am trying to create Top N chart with two dimensions and one measure.

My dimensions and Measure are as follow's:

Dimension1: aggr(if(rank(sum(Sales))<=vTopRank,Customer),Customer)
Dimension2: [Invoice Date]
Measure : sum(Sales)
vTopRank is variable

I'm trying to vary vTopRank using slider, but whenever I try to do so. I'm getting result by Top N-1.

To elaborate this. If I want Top 10 records it show's me Top 9 records.

Is there anything I am doing wrong with my Dimension1 or somewhere else?

Please let me know if you have any clue on this.

Thanks in Advance.

Re: Top N chart is showing N-1 value

bramkn — Thu, 16 May 2019 11:24:41 GMT

turn of the other values?

Re: Top N chart is showing N-1 value

Devendra_Babar — Thu, 16 May 2019 11:43:19 GMT

Thanks for Reply.
But I have already unchecked "Show Others" option from both Dimensions.

--
Thanks,
Devendra Babar

Re: Top N chart is showing N-1 value

Devendra_Babar — Thu, 23 May 2019 10:54:18 GMT

Hello Everyone,

I tried almost every possible solution available on community to solve this issue by creating different different calculation dimension and measure.

But unfortunately I didn't get anything which can solve this issue.

So I tweaked my first dimension in such a way that it will solve this issue automatically.

Here is my calculated dimension.

"IF(MATCH($(=COUNT(IF(AGGR(Rank(sum(Sales))<=vTopRank,Customer),Customer))),vTopRank),
IF(AGGR(Rank(sum(Sales))<=vTopRank,Customer),Customer),
IF(AGGR(Rank(sum(Sales))<=vTopRank
- $(=COUNT(IF(AGGR(Rank(sum(Sales))<=vTopRank,Customer),Customer))-vTopRank),
Customer),Customer)
)"

Basically here I am doing plus or minus according to given result by old calculated dimension.

This solved my issue but I am still confused about, why old calculated dimension was not giving correct answer?

Please do let me know if you ever faced such situation and found cause of it.

Regards,

Devendra Babar