Iam working on an analysis report for documents published and accessed on a website. I need to calculate the difference between the document published date and the first access date of the document. To achieve this i created a calculated field and wrote the formula:
str(DATEDIFF('day',MIN([Access date]) , MIN([Publish Date] )))
However, I require this field as a dimension and NOT a measure . howmuch ever i try, Iam unable to move it as a dimension. I also tried to convert the output as string, still not helping. If i consider it as a measure , the moment i drag it to the column, it starts aggregating the data, which i do not need.
Can anyone suggest what is going wrong?
Fixed it myself just removed the min function from the formula , dragged it to the column and changed the calculation to minimum(difference).