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:
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.