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 )
"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.
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.