topic Top N Customers in Stacked Bar chart (2 Dimensions) in App Development

Top N Customers in Stacked Bar chart (2 Dimensions)

Kris1 — Sat, 11 Dec 2021 18:47:40 GMT

Hi Team ,

I am searching in the community for the below requirement , but not getting proper solution. please help to solve this.I want

Chart #1:- (All Case) Dim1: Period, Dim2: Customer, Measure: Sum(Sale) --- Getting Proper values

Now my requirement i want Top3 customers of Only current Quarter like this based on user selection.

How to show Top customers for each quarter? each quarter having different TOP 3 customers and period data is in text format form that how to find different quarters.

Re: Top N Customers in Stacked Bar chart (2 Dimensions)

sasikanth — Sun, 12 Dec 2021 03:19:07 GMT

HI,

Try below expression,

Dim1: Period

Dim2 : Calculated Dim : IF(aggr(rank(sum(Sales),4),Period_Revitas,Customer )<=3,Customer)

Expression : Sum(sales)

Re: Top N Customers in Stacked Bar chart (2 Dimensions)

Kris1 — Sun, 12 Dec 2021 07:31:09 GMT

Hi Sasikanth,

Thank You for your valuable solution. Could you please tell me the way without derived dimension. I mean i want same result using expression or using set analysis in expression.

Why because there is another bar chart without secondary dimension (Dimension 2 : Customers),but there also i need to show top 3 or Top 5 like that.

Could you plz suggest how to derive current quarter and last 3 quarters from that data. Why because the data is in text format. I am not able to apply min , max operations.