Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I was hoping someone could help me to hide names in a row without losing the data
For example I only want to show "Martin" but not lose the rank or result
example table:
Name Rank Result
Martin 1 80%
James 2 76%
Paul 3 75%
I am hoping the result will look like the below
Name Rank Result
Martin 1 80%
2 76%
3 75%
Thank you in advance
The solutions by Stefan will likely help:
hello
you can code an expression to display/hide value on condition
-> but what is the condition ?
suppose it's rank, you could write in expression
if(Rank=1,Name,' ')
it would be based on the name
There are about 6 tables where the rank would be different for each person
Thank you
Ahhh school boy error
If I select the name it filters the results anyway making "Martin" rank 1 in all tables
but the goal is not to select ?
if it is based on a list of names, and this list is stored somewhere, you can left join this list with your data, and create a flag
in your graph, you write a condition based on the value of this flag
No not really
the names in the example represent a manufacturer - I have grouped the companys into the main parent group and used a selection box to limit the results to the top 5
but I don't want to show all results to all companys so to add in an additional layer to hide 4 of the 5 would be the preferred option (more of a view filter than an actual data one)
I hope this makes sense
if you can write an if condition, you can hide them
Hi Johnson,
In Expression you can check Firstsortedvalue(Name) using this you will get only selected name other fields will come as usual.
Thanks Regards,
Ramesh.P
I would tell you the procedure which i have followed for resolving your query
Step 1: In the data manager edit the sheet where your data is present
Step 2: click on select nulls and select paul and James and set them as 'set nulls'
Step 3: when you create an infographic you get the visualization the way you mentioned in your query.
Hope this helps