Formula: diff_days

Hello, I am using diff_days formula to subtract one date from another; while some results are correct (1st row in attached image), some are not being calculated accurately (2nd row in attached mage). appreciate if someone can tell me what I am doing wrong. 

Here is the formula I used:   diff_days ( closed date , created date ) 

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • "Date Diff" formula is being treated as a MEASURE resulting in aggregation of individual values. I guess you are looking to group on the "Date Diff" formula.

    Changing "Date Diff" formula to an ATTRIBUTE should achieve that. Please refer to point 6 in the below documentation on how to do that.
    https://docs.thoughtspot.com/6.1/complex-search/how-to-add-formula.html

    Just FYI, you can also group on a MEASURE by adding "by" keyword before the MEASURE in the search bar. For eg. "by Date Diff" in this case.

    Like
Like Follow
  • 1 mth agoLast active
  • 1Replies
  • 18Views
  • 2 Following