8 Replies Latest reply on Nov 5, 2013 8:57 AM by Jonathan Drummey

    Balance Calculation Errors When Expanding Dates

    Shaun Lynott

      I am trying to display balances over time and running into issues when my date field is either expanded or contracted.

      JanFebMar
      Balance$10$10$10

      If I roll up month to quarter, I want to be displaying the balance at the end of the quarter, in this case $10, but my viz is summing the data and will show $30.  Likewise when I roll up to year it will display $120.

       

      Are there any calculations I can use to solve this issue?  If not, the only thing I could think to do would be to make my date field not a date field and remove users abilities to drill through dates.

       

      Thanks.