4 Replies Latest reply on May 18, 2016 5:50 PM by swaroop.gantela

    Historical data based on today's top n

    Christian Vorbeck

      Hi,

       

      I am trying to create a historical line graph based on today's top 5 customers. I.e. what are today's top 5 customers, and how have their balances changed over time.

       

      I can't seem to figure out how to keep the top n filter for a specific data and at the same time look at all dates.

       

      From the below, I have hotel, delta, gulf, india, juliet as the top 5 customers as of April 2016. But, the graph is based on grand total top 5.

      I have googled like a madman, and tried all kinds of solutions, but can't quite get it right. Note, this is just an example I put together - in my actual data set there are additional filters (customer group, location, etc) that I will need to add to the dashboard.

       

      Any help would be much appreciated!