Dynamic axes from drop down list

[Sheryl Enos]

Would it be possible to make a cross table dynamic by using a drop down list to specify the chart type to be shown and having the associated values as a comma (or period) deliminated list with different column names and then use the split function in as the axis and value I tried this and the output seems to be correct ([ExpectedColumn]) but it does not read it as a column name

Is there a better or alternative way to do this

For example:

Drop down list assigned to property ${ChartToShow}

Chart A: TARGET,CONCENTRATION,TARGET_VALUE

Chart B: ASSAY,HOST,TEST_DATE

 

Chart Axis Expressions

X axis: = Expected output [TARGET] or [ASSAY]

Y axis: = Expected output [CONCENTRATION] or [HOST]

Values:max(Concatenate('[',Split('${ChartToShow}',".",1),']'))

 

Thanks!

[Khushboo Rabadia]

You can use this simple iron python script which will assign the axis values to 3 different document properties

-----------------------------------

chartexp=Document.Properties["charttoshow"]

Document.Properties["Xaxis"]= chartexp.split(",")[0]

Document.Properties["Yaxis"]= chartexp.split(",")[1]

Document.Properties["Cellvalue"]= chartexp.split(",")[2]

-----------------------------------

Where Xaxis, Yaxis and Cellvalue are the three dummy document propeties

Now in your cross table axis, just mention Vertical axis Expression = [${Xaxis}] as [${Xaxis}], Horizontal axis expr = [${Yaxis}] as [${Yaxis}] and Cell values exp = Max([${Cellvalue}]) as [${Cellvalue}]