Creating a new collection using a variable created with a formula

[Anna Fergusson]

I’ve been playing around with how much I can tidy a messy dataset (e.g. data scraped from the web) in CODAP using the functions included, and so far it’s been pretty great.

However, if I drag a variable I’ve created by using a formula (e.g. extracting a substring from the original messy string) to create a new collection I get an error (invalid reference to child attribute).

Is there a way I can do something like “paste values” in Excel to “set” the values of the new variable so I can remove the reference?

Thanks 🙂

[Bill Finzer]

Hi Anna,

I’m glad you’re having a good experience tidying your data so far.

A cool thing about formulas is that removing the formula (by editing it and deleting its text) does not change the values that have already been computed. So that will “set” the values and you can proceed to drag the attribute to a higher level.

Bill

[Anna Fergusson]

Awesome! Thanks so much Bill – I didn’t even think about trying that 🙂

Anna

[Author]

Posts