Removing Aggregate Label from Tooltip

[catherinewhite]

I am creating visuals where my main data table is referencing several lookup tables. For example, here is a portion of my main data table with values under reportingCategory. There is a Many to One relationship between this main table...

...and the lookup table:

I want to display the Student Group value from the lookup table in my tooltips. So for my column chart, for example, each column is displaying data from one row of my main data table.

Yet the tooltip looks like this:

The "First" should not be there in my mind, because only one value is being returned. When I select Count to confirm this, here is what I get:

Here is the relationship between the two tables:

The "First" is going to confuse my users. Why is it there?

[vanessafvg · Accepted solution]

firstly 🙂  if you change your bar chart to a matrix, does it give you more than one first?

you can also double click on the label where it says first and rename it.  Its just a standard really because its categorical data and you are aggregating your data, regardless of whether there is 1 or more.

[catherinewhite]

I HAD NO IDEA YOU COULD CLICK AND EDIT THIS!! Thank you 🙂