Creating a new collection using a variable created with a formula

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • August 23, 2017 at 7:56 am #390 Score: 0
    Anna Fergusson
    Participant

    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 🙂

    August 23, 2017 at 2:40 pm #391
    Bill Finzer
    Keymaster

    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

    August 23, 2017 at 6:45 pm #392
    Anna Fergusson
    Participant

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

    Anna

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.