1 Reply Latest reply on Oct 5, 2012 2:43 AM by puneeta.verma

    Moving Calculated Measure as Dimension

      Hi Friends,

         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?

       

       

      Thanks,

      Puneeta