jenschmidt
Programmer
Happy Friday! I'm not sure if I'll explain this right, so please sit tight and bear with me!
I have a report with a chart that shows top 10 Diagnosis Groups by # of visits. There are many possible diagnosis groups. Obviously, only 10 of those diagnosis groups will show at any one time.
The description for each group can sometimes get a bit too lengthy to fit nicely inside the chart box without going to more than one line, etc. I am going to write a formula that returns only the first 20 characters and then chart the top 10 on that instead of the whole description.
The problem comes in here because then the end user can't really tell what the group is when the description is cut off. I would like to put a type of legend next to the chart that gives the full name of only the groups that were pulled into the chart.
Is there a way to look at what gets put out on the chart at run time and only show the full description for those?
Thanks for your help!
jennifer.giemza@uwmf.wisc.edu
I have a report with a chart that shows top 10 Diagnosis Groups by # of visits. There are many possible diagnosis groups. Obviously, only 10 of those diagnosis groups will show at any one time.
The description for each group can sometimes get a bit too lengthy to fit nicely inside the chart box without going to more than one line, etc. I am going to write a formula that returns only the first 20 characters and then chart the top 10 on that instead of the whole description.
The problem comes in here because then the end user can't really tell what the group is when the description is cut off. I would like to put a type of legend next to the chart that gives the full name of only the groups that were pulled into the chart.
Is there a way to look at what gets put out on the chart at run time and only show the full description for those?
Thanks for your help!
jennifer.giemza@uwmf.wisc.edu