Hi,
i've got a line chart that is filled by user choices in selection lists. The three selection lists (hierarchy exists - 1st list choice determines what choices can be made in 2nd list and so on) are getting filled by different select statements, each one has a seperate table as source (assignments are determined via IDs). My line chart is refreshed whenever a choice is made in the selection lists via dynamic action (Event: change). So far, so good - everything works fine till this point.
When the chart is refreshed, I would like to get the initial view, just as a user made a choice in the selection lists. The legend does not get refreshed and keeps the setting for "hide/show" once modified before and the view in the chart stays at the same zoom level as before.
Is there a way to refresh the chart and legend and come up with the initial view?
I would really appreciate any help!
Cheers,
Phil