Expression or Set Analysis

[#1]

Hi.

I display a gauge that shows the score from one of five psychometric tests carried out on a client (self-esteem). If this is not the first time that the client has undergone the test then I wish to also display a gauge that shows the score on their previous test.

The data table is created using Crosstable. The gauge value that shows the current selection set is generated by the expression:

=num(sum(if(DimPS='1. Self-esteem',DimDataPS)),'##')

Where DimPS is the attribute field holding the 5 domains of analysis (of which 1. Self-esteem is the first) and DimDataPS holds the values. The gauge only appears when there is only one record in the selection set. The key attributes for each record are client_number and visit_number. So the above data might be for client 36251 and the data shown is for their 3^rd visit. How can I also display the data (score) for Self-esteem for client 36251 on their 2^nd visit in a separate gauge (so it ignores the current selection set).

Thanks Neil

[erichshiino]

Hi, I created a sample application with an expression that would use the selection to identify a previous result and present it on a chart.

I believe you can easily adapt it to your case.

Just let me know if it works for you