Forum Discussion

Chitemerere's avatar
Chitemerere
Responsive Resident
5 years ago
Solved

Creating a Relative Frequency table

I have the following dataset in a table named 'Major Funding':   Word government donors igf government government donors igf government donors ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Chitemerere ,

    You can try a measure like

    RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),allselected('Major Funding')))
    or
    RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),all('Major Funding')))

amitchandak's avatar
amitchandak
Super User
5 years ago

Chitemerere ,

You can try a measure like

RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),allselected('Major Funding')))
or
RowCountMajorFunding %= divide(COUNTROWS('Major Funding'),calculate(COUNTROWS('Major Funding'),all('Major Funding')))

  • Chitemerere's avatar
    Chitemerere
    Responsive Resident
    5 years ago

    Many thanks, works like a charm

     

    Regards,

    Chris