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

    calculating measure based on dimension's field

    Глеб Аитов

      Hello,

       

      I have Status as Dimension and Clicks as Measure.

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

       

      Screenshot_8.jpg

       

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

      CR% =

           sum( clicks) /

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

       

      It returns:

      Screenshot_9.jpg

       

      What is the correct way to make it happen?

       

      Thank you!