Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Suny,
Another question for you - is it possible to pre-filter the dimension used as the point layer to only plot values that contain a specific value? Much like set analysis, I want to plot my records by country but only were their STATUS = 'PROPOSED'. I am trying to avoid having the user apply the 'PROPOSED' filter from the filter pane.
Sorry to bother with such a basic question but I couldn't find any posts even remotely related to this question.
Thanks!
Ben
I think it could be restricted with a set analysis condition like: {< STATUS = {'PROPOSED'} >} within the dimensions/expressions. Another and maybe easier way might be just to duplicate the dimension/measure fields within the datamodel by replacing the field-values with null() if the condition isn't fullfilled.
Beside this I'm not sure if it's really useful to use/build such kind of logics, see: Let-the-User-Select.
- Marcus
Hello Ben,
I hope you don't mind me following this question.
I am sitting with a similar request, but rather than restricting to a field, I would like to show Events which happened on the max Date. Normally I let the user select what needs to me seen, but I have built a dashboard and would like to highlight only certain items, without user selections. In a table I am able to show the most recent events but I have been unable to reproduce these events on a map 'automatically'. "count({<[Class]={'XXXXXX'}, [Date]={'$(=max([Date]))'} >} Key)" is what I use in the table expression.