Create simple line graphs using dynamic data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm setting up a workflow to carry forward simple calculations (ratios/differences) to compare different values for an age range against a benchmark.
Each table of values is populated in different files and the no. of files in the directory will constantly change.
Hence the current workflow uses a batch macro to import all the files in the directory and then find the lowest values from all the files and create a table of the same to carry forward the calculations mentioned above. It then creates interactive charts to represent those differences and ratios against the benchmark.
However, from my experience of the interactive chart it seems very manual where the x-axis and y-axis have to be manually chosen by the user as per the number of layers. If ever the number of files change in the directory the workflow breaks at the interactive chart tool.
Would be great if somebody could help me create charts using dynamic data
- Labels:
- Custom Tools
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
With a sample data it could help better.
But what you can do is after reading the directory, go through the steps after the dynamic select put the graphics in another macro that will allow you to change the parameter values.
By an input macro it passes the records and by control parameters you can pass parameters for the graph to be dynamic.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@payalsaria921
I agree with you.
For the interactiev chart, the data schema has to be kept unchanged.
Maybe we can repare a Field Name Data Input then Forcedly changed the Field Names with a Dynamic Rename tool?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the suggestion. However the file names is not an issue but the no. of fields that is causing the interactive chart tool to break. For example I have shared two attachments, one with the same no. of files which the interactive chart tool was configured against. And the other one is where I have removed one file from the directory which hence causes the interactive chart tool to break.
The goal is to make sure that the interactive chart tool works for n no. of files present in the directory.
![](/skins/images/7055FCCD30DFCE122E076EE2F99E1E7F/responsive_peak/images/icon_anonymous_message.png)