Edit existing data group for new value

[matan_benyishay]

Hello,

I am trying to edit an existing Data Group. There is a new value in the source data that did not exist when I created the groups. However, this value does not show up under "ungrouped values." How can I "refresh" the data groups to show this value (I've tried refreshing the query).

In the screenshot, the new value in the source column (Program areas) is called "Specialized." You can see that the Program area (groups) column is just reproducing it verbatim. But in the grouping dialog, it does not show up on the left pane under ungrouped values.

Any suggestions? This grouped column is in use in many places in this report and re-creating it would be significant work. Thanks!

[Idrissshatila]

Hello @matan_benyishay ,

Did you check if this group is included in any of the groups, just check the groups and see if you can find it there.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[matan_benyishay]

Hi there, I did check and could not find it in any of the existing groups. That is reinforced by it showing up as "Specialized" in the grouped column, when that wasn't one of the groups I had initially created (nor can I see it in the groups list).

[Idrissshatila]

Hello @matan_benyishay ,

Try creating it again if its not that hard, and see if it shows, maybe this group won't recognize it because it's made before.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[matan_benyishay]

Hi,

Strangely, the new values do not show up even in a new grouped column. "BH-Specialized" is still absent even in a new group of the same column. 

However, if I create a new source column (program area new) and set it equal to the original source column, then I see updated values.

It's like the possible ungrouped values don't get refreshed once you have grouped them once. If that's the case, it makes grouping basically useless.