topic Re: customer sales report in App Development

customer sales report

Wed, 18 Nov 2015 12:33:46 GMT

Hi everybody,

I making a sales report,

How can I show the customers that stooped buying and also showing customers that there sales started slowing down?

Re: customer sales report

reddy-s — Wed, 18 Nov 2015 14:54:39 GMT

Hi Jhonatan,

Make use of a scatter plot, so that it takes 3 measures

measure 1 being the sales/customer

Measure 2 and 3 being the time since the last purchase. This will give you the size and you can color code the bubbles with an expression.

Its going to look some thing Like this:

Thanks and Regards,

Sangram Reddy.

Re: customer sales report

Thu, 19 Nov 2015 15:00:26 GMT

thank you Sangram Reddy ,

but i need to somehow show it on a pivot table....

still need help...

Re: customer sales report

reddy-s — Thu, 19 Nov 2015 16:56:57 GMT

Hi Jhonatan,

You can show it in a very intuitive way using a pivot table as well.

Try creating some thing like this.

Let me know if you need help with this.

- Sangram

Re: customer sales report

Mon, 23 Nov 2015 11:20:36 GMT

Hey Sangram i need some help,

Again as I originally posted I need to show the customers that recently have stopped buying on a pivot table…

Re: customer sales report

reddy-s — Mon, 23 Nov 2015 18:07:10 GMT

Hi Jhonatan,

What you are referring here is Customer Churn. So it would be helpfull to find out the number of days it has been since their last purchase.

Ex: If a customer made a purchase on 1st of August and no purchase there after, then no of days since the customer has bought something would be today() - 1st of August = x no of days. You can use this in your pivot table as a measure.(Order this measure , so it would give you the list of customers who have no bought any thing from a long time)

If you are looking at a higher level like the departments or Franchises, looking at the trend of Customer churn will also be very useful.