Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

GENERATESERIES with dynamic value

I would like to pass a dynamic end value to the GENERATESERIESE function. I have an imported (not calculated table), one of its collumns contains the numbers that i would like to use as the end valu...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Goodmorning Anonymous 
    Calculated tables cannot read the filter context. What are you trying to acheive is not possible. 
    I would suggest to create a completely new table as follows https://www.dropbox.com/t/2rv9ENz3TZdvyAXQ

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Anonymous 
I believe I can help on this. Please explain what is your ultimate goal and what are the expected results?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

The "Num" table will serve as a base for an other function, that will split the title sentences to words.

The "Num" table is just a list of numbers starting from 1 and ending with 100 (for example).

 

The problem with this is that when I visualize the table I will get the words, but also additional empty lines, because the tables length will be exactly 100 rows (the user will scroll through empty rows --> not uder friendly ). In addition, if there are more than 100 words in the title, then not all words will be shown.

 

My goal is to create the 'Num' table exactly as long as the amount of words in the given title.