Modeled Data Source - array vs merge?

I have 6 sources of revenue. Currently, I build a hidden table inside a klip that uses ARRAY functions to merge these into one complete table of transactions (IE- for a single "Date" column, I ARRAY and DATE_CONVERT the date column from each source). Then I use results references in any charts I want actually visible to the user. But it means rebuilding this table in any klip where I need revenue as a data source. Am I overlooking something in the modeled data source feature where I could do this once instead?

If not, it'd be awesome if this was an added feature. Basically, create a new data source that's a blank table, then for each column, write any formulas referencing any of your existing data sources as you would inside a klip.


Please sign in to leave a comment.