LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dglavastorm

I have a report that currently uses 2 graph parameters that are manually declared prior to running the report - "Report Date" and "Previous Report Date" which is always 7 days previous.

I use "Previous Report date" for only one function - importing an Excel File for which the Filename line is "X:\Team Variation - WE {{^Previous Report Date^}}.xlsx".

Is there any way, via a filter or formula or something, to consolidate this so there is only one graph parameter needed to be entered - "Report Date" - and this previous import node knows to take 7 days off the "Report Date" ?

Cheers,

Dave

PS - I found an old thread saying this can't be done but that was from July 2010 - hoping there is an update :-)

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rhallmark

This would just address your situation, but you could use a Directory List node to bring back all the files in the X: directory with the pattern of "Team Variation - WE " and then use a filter node to bring back only the report you want to look for based off of the Report Date.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dglavastorm

Thanks Rhallmark - Workaround worked fine for this situation, so great suggestion and thank you.

I assume though from the workaround that the answer is still "No" to the question of declaring a parameter through a node?