topic Re: How to get the number of sales of the best seller last year? FirstSortedValue and Count problem in Visualization and Usability

How to get the number of sales of the best seller last year? FirstSortedValue and Count problem

ThiagoOliv — Mon, 10 Apr 2023 20:04:09 GMT

Hello guys.

I'm new to this, and I'm trying hard to find an answer. Sorry if this is a common problem.

I have database like this: Seller, OrderID, YearSale

I'm tyring to display the number of sales of the best seller in the last year (of the filtered years, I need only the last one).

I came up with:

=count( { <YearSale={$(=num(max(YearSale)))}> + <FirstSortedValue(Seller, -Aggr(count({$<YearSale={$(=Max(YearSale))}>} distinct OrderID), Seller)) > } distinct [OrderID])

I think I'm doing something simple in a hard way and honestly I don't know what's actually happening here.

I'd apreciate any help.

Re: How to get the number of sales of the best seller last year? FirstSortedValue and Count problem

vinieme12 — Tue, 11 Apr 2023 03:33:56 GMT

try below

= FirstSortedValue(count({$<YearSale={$(=Max(YearSale))}>} distinct OrderID) , -Aggr(count({$<YearSale={$(=Max(YearSale))}>} distinct OrderID), Seller))

=Max ( AGGR( count({$<YearSale={$(=Max(YearSale))}>} distinct OrderID) , Seller) )

Re: How to get the number of sales of the best seller last year? FirstSortedValue and Count problem

ThiagoOliv — Tue, 11 Apr 2023 20:13:47 GMT

Many thanks! It worked