

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Distinct values for dimension in a chart
Hi Guys,
For one of my dimensions i am getting a multiple value
Dimension = Players
Value= Jack F
Jack F is coming up twice in the bar chart. The players field is created from multiple string manipulations and concatenation with other data sources. I am asking if there is a solution just in the front end for this?
Such as =(Distinct,Players)
Thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Aaron,
The amount of information is not huge, but if you are experiencing multiple instances of a dimension on the same axis that would mean there dimensions are not unique. Most likely there is a space before/after the name or the space between 'Jack' and 'F' is one or two spaces.
It is much easier to sort this in the backend, by simply using a Trim(Players) as Players in the script. You can try this in the front end as well (as calculated dimension) but I'm not entirely sure how the result will pan out.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change ur dimension in the script as follow:
Capitalize(trim(Players)) as Players
