4 Replies Latest reply on Oct 14, 2013 7:58 AM by Ed Solomon

    How to create a complex filter which not using an aggregator?

    Ed Solomon

      I have searched the forum and Internet, but found no solutions, maybe that due to my inexact query string. I am desired to know how to solve my problem. Any help will be appreciate, thank you.

       

      The data is shown as below:

      QQ截图20131014182456.png

      I have drawn them to a line chart:

      b.png

      c.png

      My purpose is to display products whose product_count are "top n by desc" at specific date.

      For example, at 2013-10-4, the top 2 product are product_c(green) and product_e(purple), I want to get the chart shown as below:

      d.png

      at 2013-10-3, the top 2 product are  product_e(purple) and product_d(red), I want to get the chart shown as below:

      e.png

       

      I don't know how to achieve this result, I need your help, thanks again.

      I have attached the file product.twbx.