2 Replies Latest reply on May 14, 2012 3:56 PM by jeanchristopherodrigue0

    Filtering a viz without altering the values

      Hello guys,

       

      This is probably a simple questions but I searched the knowledge base and forums without finding my answer.

       

      I have a viz which charts the running total account creations for a service across days, when I don't use a date filter everything displays fine, the total increases with time starting from the first day. Though, when I put a filter on the date and filter on the last 30 days, logically, the table calc only takes into account the last 30 days which alters the results dramatically.

       

      So, how can I filter on a date (last 30 days for example) and still have my table calc work from the beginning of my data set to display the correct total amount of accounts created?

       

      Thank you guys!

       

      Jean-Christophe