Rank visit reason

[Former Member]

I have a report with [Encounter.Reason For Visit] which lists reasons patients have visited the hospital. If I wanted to rank any that are the same in a field how would I do that? For example, if I wanted to see what the top ten rankings were for any repeating visit reasons such as pneumonia where would I start on this report? I have included a screen shot. Thanks!

[Former Member · Accepted solution]

On what Object you would like to do Rank?

In your example you said - Top ten repeating visit reason, for that you would need to create a Measure Object ( you can only have Rank on Measure Object ).

Place a BREAK on object you want to place a Rank and than do Count of that Object and Place a Rank(top 10) on Count by using your Reason for Visit Object.

[Former Member · Accepted solution]

Ok. So the object is [Reason for Visit]. I looked at the Rank function and I'm not sure about the syntax for it. Can you provide me with an example for how it would look?

[Former Member · Accepted solution]

So I was able to place the break on the object which split the report by patients who have the same encounter reason. Now for the next part my rank and count have these syntaxes:

[Former Member · Accepted solution]

Hi,

Check this out.