Non-numeric min/max

Another option to meet the requirement could be to use guidelines http://www.goat1000.com/svggraph-guidelines.php

Marking the chart dynamically where there is a marketing event would be a good visual.
I can get a single guideline working using frx:guideline="100", but the examples use array and I can't figure out how to use arrays in frx.

Further, don't know how I would be able to generate multiple guidelines dynamically. The only think I can think of is give them 0 value if there is no data for them, and assume they will appear on the axis.

Note - this is all for multiline charts.

Parameters or fields are other options - but I don't know how to automate the values:

• Parameter - I can get the div to render or not based on a parameter using frx:if={parm:marketing}
• Field - setting a field value also works e.g. frx:field id="marketing_test" with default of 0 or 1, then the filter becomes frx:{marketing_test}

Is there a way to either autoselect a hidden parameter based on the other parameters as inputs, or to populate a filed value based on a field?
If not in the frx file, in the js?

Thanks

It seems I have a solution:

• I nested the graphs inside a parent div with a 1 line query
• Now the parent div queries a data block returning a single 1:0 value for a field "marketing".
• I can now show:hide graphs based on the value in this field:
• frx:if="{marketing}" - show the 3 series including marketing
• frx:if="!{marketing}" - show only the 2 series graph

AS it appears this is a solution, hope it helps someone else.
I'd still be interested in knowing how to
- render graphs with null fields
- dynamically alter graph values using tokens
- automatically setting parameter values

Thanks for your response David - further clarification as follows:

Arrays: The issue is how to use an SVG feature such as Guidelines http://www.goat1000.com/svggraph-guidelines.php which uses arrays e.g. array( "guideline" => array(10, "Target", "y"). As above I could get a single guideline working using frx:guideline="100" but no idea how to get the other variables in.

Null Values: Actually the case here is when a single series is null, but there is data for the other series. In my case target, sales have data but marketing may or may not. The chart will render if a single data point in the marketing series is available, but not if the whole series is null. Certainly suppressing a single series would be good. Less important is the case for showing a whole graph if no data at all - maybe interesting if for presentation purposes it is better to show something than nothing, even is just the axes but an empty chart.

Automatic Parameters: Does that mean I could dynamically set the default using e.g. frx:parameters="marketing={marketing}" ? Worth a try...

Graph Values as Tokens: This relates to the original post points about unsuccessfully trying to use tokens to:

• make the value 0 instead of null and hide it - however I tried unsuccessfully to conditionally make it transparent by using a token for marker colour e.g. if marketing is null then 'transparent'
• put the series 'off the chart' by making the value high than frx:axis_max_v - however I can't get a token to set this dynamically - is it because there are many rows (albeit with the same value) and it needs only one?

I couldn't get the tokens to work so any tips here most welcome.

Many thanks

Thanks David - RE Token, I can't seem to get anything to appear just using {row/max_value} - how do you specify the field? e.g. If I have a field named "Volume", something like frx:inner_text="{row/max_value[Volume]}" ?