3 Replies Latest reply: Jul 19, 2018 6:43 AM by Andrea Gigliotti RSS

    calculating measure based on dimension's field

    Глеб Аитов



      I have Status as Dimension and Clicks as Measure.

      I need to calculate CR% Measure = Click / Clicks <view_site>:




      When I try to build a straight table with the following formula:

      CR% =

           sum( clicks) /

           sum( {<status={'view_site'}>} clicks),


      It returns:



      What is the correct way to make it happen?


      Thank you!