LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Texnoti

Hi!

Running a test with three customers (Turnover) over three years (2013, 2014, 2015).
Showing in a line chart (with Year on x axis) produces 0-2300.
Limiting the x axis with 2013-2015 works.

How to make limits dynamic?
minYear-maxYear?


Kind regards
thomas

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

There is an option to use a field to specify the axis limits. I tried setting it with two inputs, but I'm getting an error with it. A work-around is to join the field containing the axis range with the data. Try the attached.
Attachments:
Xrange.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi Thomas,

If the X axis data type is a date, the InFlow nodes will automatically determine the X-Axis range to be shown in the line chart. I have attached a Data Flow that shows this operation (in the left hand example). However, the range is not dynamic where the X-Axis field's data type is numeric.

A number of the InFlow nodes were updated in a recent Lavastorm Analytics Library (LAL) release to allow the values for the XAxisRange and YAxisRange parameters (on the Optional tab) to be sourced from an input field.
The attached Data Flow shows the default operation (top right) and also shows the range of options where the XAxisRange and YAxisRange parameters are used to 'zoom in' on the data area of the chart. The options include: static assignment of the X-Axis range; dynamic assignment of the X-Axis range using the min/max values in a specified field; and dynamic assignment of the X-Axis and Y-Axis ranges using the min/max values in two specified fields using a composite node to calculate the ranges.

LineChartDynamicRanges.brg

Best Regards,
Adrian