2 Replies Latest reply on Jul 6, 2016 9:07 AM by Prasanth Regupathy

    Visualize new trends with percent of total

    Prasanth Regupathy

      My objective is to spot surge in product sales. In this case, each record is a sales transaction. For example, 2 units of Arowana were sold in April and 23 units of Arowana were sold in May. I have used percentage total to spot surge in sales. I would like to visualize this surge in sales. Another problem that I'm facing is filtering by number of records. In order to consider a product to be in my list, it should at least have 7 units sold in total. For example, Texas cichlid has 100% total in May is surging. However, as total number of sales is 1 which is less than 7, I do not want want to see this record. It would be great if I can give control in choosing this threshold.

      Capture.JPG

      Thanks in advance