Showing others (exluding selected top customer)

[Anonymous]

Hello,

could someone tell me how to show OTHERS in a separate graph?

Prequisites:

Dimension limited to top n customers using input variable, selected show others in current graph

Want to remove show others from current graph and show only top n

Want to show the Others (from the current graph) on a separate graph (excluding those shown in the top n)

(OR if someone knows how to cut/rescale the Others bar not to ruin the scale for the above but still show the correct value)

current:

[sunny_talwar]

May be use Rank function to show the others. Try like this:

If(Rank(Expression) >= 15, Expression)

[rubenmarin]

Hi Mikko, the option to remove the totals is shown in the dimension limits tab, you can uncheck the option.

To only show Others you can make a copy of the chart and add a condition to the expression;

If(IsNull(CustomerField), YourExpression) // This will show only the columns with more than one customer

[Anonymous]

Hello,

i would like the OTHERS to show still as a single bar ...

[sunny_talwar · Accepted solution]

You can create a synthetic dimension

Dimension

'Other'

Expression

Sum(Aggr(If(Rank(Expression) >= 15, Expression), YourDimensionName))