Forum Discussion

hsackman's avatar
hsackman
Frequent Visitor
2 years ago

Calculate Based off Column Total ONLY

Hello,

 

I'm trying to get a weighted conversion based off the total of a different measure. 

'Measure' is taking the count of agent ID over 'Paid Leads', but I only need the total. Problem is 'Count of AgentID' is a different data set so it is not tied to the indicators of each line. 

 

I need to use the total of 'Mesaure' divided by the total of 'Conversion' multiplied by each lines conversion to weight it appropriately.  

 

Line 1 example:  = (0.32 / 18.0%) * 24.1% = 43.5% 

The goal would be to do that for each line.

 

Is there a way to do this?

Need Help

3 Replies

  • Thennarasu_R's avatar
    Thennarasu_R
    Icon for Responsive Resident rankResponsive Resident
    2 years ago

    HI hsackman 

    Its Possible we can do.Below i mentioned the measures . You can this one . I put some refference name instead that one you can change respective measures.

    Measure=Divide(Measure ,Sumx(Values(Categorycolumn),Conversion Measure)

    Thanks
    Thennarasu R

    • hsackman's avatar
      hsackman
      Frequent Visitor
      2 years ago

      I can't seem to input the Categorycolumn, that too is a created measure/calculation. How do I do this?

      • Thennarasu_R's avatar
        Thennarasu_R
        Icon for Responsive Resident rankResponsive Resident
        2 years ago

        hsackman 

        Then in table visuals how measures are spilt .We have one column that u used in first column based on that column all measues values are spilt .

        I dont know that one instead of that i said like Category whatever column you have mention over there.

        Thanks,
        Thennarasu R