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 ...
Need Help
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