Maybe a dumb question but I can't figure out how to do it or if it can be done by searching on the Community.
I have a source sheet of client data that's summarized into 3 Summary fields by the assigned specialists. I've then pulled those 3 fields separately into several Summary Reports that I used to build tiles on a Dashboard.
The problem is that the Summary fields on the source sheet need to be specific because there are so many of them (i.e. John Smith Total Client Count, John Smith Total Points Count, John Smith Over/Under, then repeat for ~50 different people along with several other Summary Fields). However, because each tile on my Dashboard represents a different data point (Tile #1 shows the client count for each specialist, Tile #2 shows the total points for each specialist, and Tile #3 shows the over/under for each specialist), it's unnecessary to have the full Summary Field title show. In fact, it makes the tiles look pretty unruly because several of my team have very long or hyphenated names (i.e. Jane Loise Smith-Doe Total Points Count). Additionally, because there are so many people on my team and because we're using a Summary Report, the only chart that makes sense is the bar graph which means that I either need to use a legend, which makes it very hard to read, or I need to "switch rows and columns", which make the graph super tiny so it can account for 3 inches of Summary titles.
So, is there any way to change the name of the Summary fields on the Summary Report or dashboard so that the dashboard tiles show "Jane" instead of "Jane Loise Smith-Doe Total Points Count" without changing the Summary field title on the source sheet?
