topic Re: Other values in bar chart in App Development

Other values in bar chart

Matt — Sat, 16 Nov 2024 07:08:51 GMT

Hi, I created a bar chart with the Others expression. On the dimension limit tab I chose to show only the largest 3 values.

When I click on the Others now, I get again the largest 3 values (2 plus Others) and again, again..

All I wanted to show was the top 3 values (which I got),but when I click on Others I want to show all left values and not again top 3 (from the left). Is it possible to make it?

Thank you!

Re: Other values in bar chart

juliensaintmaxent3113 — Tue, 11 Dec 2018 14:16:19 GMT

hi,

it's not possbile, you can create two charts one with the top3 (uncomment show other) and the second with a function rank in the measure to show all without the top 3

Bye

Re: Other values in bar chart

santoshknc — Wed, 12 Dec 2018 12:13:47 GMT

Hi,

Can you please recheck the properties and also if possible can you change the value of 'Others' to some other name and test it and then filter for only Top 3 and also make sure you disable 'Show Others' checkbox

Thanks

Santosh.

Re: Other values in bar chart

Matt — Wed, 12 Dec 2018 15:41:10 GMT

Hi, unfortunately the second part of your advice does not work. Disabling 'Show Others' caused showing only top 3 values.

Re: Other values in bar chart

santoshknc — Wed, 12 Dec 2018 15:44:13 GMT

Hi,

I believe thats what you require right to show only the 3 values in the pie chart.

Thanks

Re: Other values in bar chart

Matt — Wed, 12 Dec 2018 15:45:37 GMT

All I wanted to show was the top 3 values (which I GOT),but when I click on Others I want to show all left values and not again top 3 (from the left)

Re: Other values in bar chart

Anonymous — Fri, 14 Dec 2018 12:19:48 GMT

Create inline table as like

load * inline [

Optionsfield

Top 3

Others

];

Write a condition in the measure that

if(getfieldselection(Optionsfield)='Top 3',"sum(condtion where you can exclude others )",

if(getfieldselection(Optionsfield)='Others',"sum(condition where you can exclude top3 )"

))

Re: Other values in bar chart

Anonymous — Fri, 14 Dec 2018 12:20:34 GMT

Take optionsfield in a filter

Re: Other values in bar chart

Matt — Mon, 17 Dec 2018 14:58:13 GMT

Condition is not working 😞