- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to conditional dimension in Radar Chart?
The variable 'Values' is used as dimension, which has five values: A, B, C, D, E.
I like the chart to use A, B, C as dimensions. I enable 'conditional dimension' in the dialogue box and input
match(values, 'A', 'B', 'C')
However, the chart still shows all the dimension values. Any ideas on the solution? Thanks.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Dennis,
It is better to filter the vars on Expressions with Set Analysis:
COUNT({<Values = {'A','B','C'}>} DISTINCT ID)
Regards!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The conditional dimension is for showing or hiding the entire dimension itself. It's not an expression to show or hide some dimension values. What you want is to use a calculated dimension. There you can use an expression like: =if(match(Values, 'A','B','C'), Values)
Is the name of the field 'values' or 'Values'? Field and variable names are case sensitive.
talk is cheap, supply exceeds demand
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Dennis,
It is better to filter the vars on Expressions with Set Analysis:
COUNT({<Values = {'A','B','C'}>} DISTINCT ID)
Regards!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for reply. The calculated dimension gives an additional dimension beyond A B C. I am not sure why this happens.
Manuel's solution works perfect! All I need is to replace count as sum.
Sum({<Values = {'A','B','C'}>} Score)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, Manuel.
This works out perfect. All I need is to replace count as sum.
Sum({<Values = {'A','B','C'}>} Score)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Dennis, I am glad that the solution is what you need.
Regards!