Hi all,

I’m currently prototyping an ROI calculator. This calculator needs to be able to generate bar graphs based on calculations that will update based on users updating their own data into a few text fields.

I’m using this amazing example from matie1987 as a starting point to have the bar graphs animate to scale based on repeater data.

Top Selling Albums in the last 20 years. (Interactive Bar Graph)

His example was in Axure 7, so I’m reverse engineering it a bit to work in Axure 8.

Where I’m getting a bit stuck is how to make the repeater data dynamic (in other words, if I surface a few text fields for the user to enter some numbers, those numbers need to generate new values in the repeater table, and then the bar graphs will update based on the new repeater data).

When I started going down this path, I assumed that I could add functions in the Repeater table cells, but I now see that the Repeater data is “hard-coded”.

Is it possible to do what I’m asking?

Here’s an over-simplified version of what I’m trying to do, just so I can see what, if any, approach would work:

User Input Data:

x = Hourly wage

y = Number of staff

z = average hours worked per employee/year

Repeater Data

Column Title = Total Yearly Salary

Column Value = (x*y*z)

Within the Repeater table, we’re also modeling growth, so we’d add extra rows to illustrate changes in yearly salary over time based on adding <n> of employees each year, as well as a large number of other dynamic calculations for other columns in the Repeater table.

I’ve been able to create Global Variables to provide a starting point for each math variable, but I’m not that fluent with variables, so it’s not entirely clear how I should go about building my .rp file so that I can have a user text field that updates the values within the Repeater so that the visualization of the bar graphs represents the user input data.

(The equations we want to use are much more complex than this example, but I think once I learn how to update the repeater data with this simple example, I should be able to figure out the rest

Thanks in advance for any pointers!

Cheers,

Jeremy