Solved: Display name in chart view not displaying referenc... - Page 2

arrakeen · 02-21-2023 12:59 PM

Hi there,

I have a table that includes the top countries with respective percentages for each entry (row). The layout is country name, % of that country, so:

Column A: name
Column B: Top 1
Column C: Top 1%
Column D : Top 2
Column E: Top 2%
Column F: Top 3
Column G: Top 3%
So e.g. one row has USA - 20% - UK - 15% - Japan - 12% (label - value - label - value - label - value).
I've created a chart view that is filtered only on the selected row with the columns Top 1%, Top 2%, Top 3% with a col series chart type.
By default, the display name of each entry is the column name (so "Top 1%" etc). What I want to achive is to change the display name of "Top 1%" to the actual value of "Top 1" (e.g. "USA").
When setting the display name of the respective chart column to a fixed value, e.g. "Test xyz" it works (it displays "Test xyz"). However, it does not work when referencing the value of another column, e.g. [Top 1].
In the expression assistant, the test functionality shows that the values are actually returned (so, the expression is correct). But it doesn't work in the chart.

Any ideas how I can achive this ?

Marc_Dillon

I can see 2 options for you.

1. Create a new grouped action. Add your existing LINKTOFILTEREDVIEW action as the last action in the group, and replace it's position in your app with the new grouped action. As a first action in the group, set the value of a new [flag] column to NOW(). This way, you can lookup the selected/flagged record's country value in your Display Name expression with: LOOKUP( MAXROW())

2. Adjust your data structure as I first mentioned. You'd need your new structure to look like this:

unique-key	common_identifier	number	country	value
	a	1	United States	29
	a	2	United Kingdom	15
	a	3	Mexico	3
	b	1	Brazil	15
	b	2	United States	1
	b	3	Portugal	0.3

In this new table structure, you can set the [country] column as the Label, then it will be what appears by default on the chart for each bar.

View solution in original post

Display name in chart view not displaying referenced column values