topic Re: SALES REPORT: TOP CUSTOMERS in App Development

SALES REPORT: TOP CUSTOMERS

Wed, 09 Dec 2015 14:16:48 GMT

hey evryone short questiion regarding a sale report , how do i present my top customers and my wickest customers?

Re: SALES REPORT: TOP CUSTOMERS

reddy-s — Wed, 09 Dec 2015 14:46:23 GMT

Hi Jhonatan,

A scatter plot would be the best way to show it. It would be very easy to pic the outlays.

You can even go with colour coding (RAG status) to give a better visual appearance.

Re: SALES REPORT: TOP CUSTOMERS

JonnyPoole — Wed, 09 Dec 2015 15:06:30 GMT

Have a look a the following. 2 horizontal bars. One with top 5 and other with bottom 5

i made the min/max of the axis the same.

The measure is sum(Sales) so the max is the maximum value by customer (i have country)

Max( total aggr( sum(Sales), country) )

and the min is similar

Max( total aggr( sum(Sales), country) )

i also moved the axis on the top bar to the top and changed the colors

I think its a decent approach to show the top/bottom 5

Re: SALES REPORT: TOP CUSTOMERS

Thu, 10 Dec 2015 11:54:06 GMT

i did it and got this....

Re: SALES REPORT: TOP CUSTOMERS

Thu, 10 Dec 2015 11:54:26 GMT

Max( total aggr( NIS_TOTPRICE, CUST_CUSTNAME) )

Re: SALES REPORT: TOP CUSTOMERS

JonnyPoole — Thu, 10 Dec 2015 13:42:14 GMT

The expression is syntactically.incorrect. The first argument for the aggr () function is a chart aggregation function like sum()

Example:

Max( total aggr( sum(NIS_TOTPRICE), CUST_CUSTNAME))

Re: SALES REPORT: TOP CUSTOMERS

Thu, 10 Dec 2015 13:49:10 GMT

i don't see where are u placing this expression....

Re: SALES REPORT: TOP CUSTOMERS

JonnyPoole — Thu, 10 Dec 2015 15:38:19 GMT

Take a look at the bottom right part of my 2nd screenshot above. I'm.using it to.define a min or max on the X axis scale. That way the scales for both apps line up and it's useful to see how far apart the.top.customers.are.from the bottom.customers.

Re: SALES REPORT: TOP CUSTOMERS

Tue, 15 Dec 2015 13:31:09 GMT

Hey i used your suggestion and i am getting a table with 10 customers,

but still no getting the top/lowest ....

Re: SALES REPORT: TOP CUSTOMERS

JonnyPoole — Tue, 15 Dec 2015 13:52:45 GMT

It LOOKS like you are getting both top 10 and bottom 10 in the tables. Perhaps you want to hit the 'Sorting' property on the right to ensure you are sorting by ILS Total ? To me it looks like only the sort is missing.

Re: SALES REPORT: TOP CUSTOMERS

Tue, 15 Dec 2015 13:55:46 GMT

you are absoultliy wirght but for some reason it only gives me sorting the customer name and not the sales....

Re: SALES REPORT: TOP CUSTOMERS

JonnyPoole — Tue, 15 Dec 2015 13:59:42 GMT

Does it allow you to sort the Customer 'by expression' . Then you can re-enter the same measure expression.

Re: SALES REPORT: TOP CUSTOMERS

Thu, 17 Dec 2015 09:08:31 GMT

thank you all!! the default error was due to the fact i took a pivot table and not a flat table