I've got a filter setup that takes a parameter value and filters on a rank to include everything less than or equal to the parameter value.  What I'm doing is letting the user decide how many results they want to see, eg a Top 10 list.  This works perfectly, but for some of my rankings I'm interested in both the Top 10 rankings and the bottom 10 rankings, the top rankings represent increases, the bottom 10 represent decreases.   The top 10 is relatively easy as it's always going to be rankings 1 to 10, but the bottom 10 will always be MAX(Ranking) to MAX(Ranking)-10, I don't know how to modify my filter to reflect that.  Does anyone have any ideas?  I'm working in EG5.1   I can go back to the step where I'm adding my rankings and add another computed column for the inverse rankings, but I'd rather avoid this if possible as it means adding another 15 columns of data to an already large dataset and the information is already in the dataset.   Thanks ... View more

I'm building a data set in Enterprise Guide 5.1, the contents aren't important, but each row of data has a variable attached to it to specify the Region and the Sector that the row relates to.  When I get to the end of my process I have a single table that exports to Excel as a single file.   At some point the dataset is to be broken down by both Region and by Sector, ideally I'd do that in Enterprise Guide and with roughly 10 Regions and 10 Sectors it's not too difficult to usef Filter-Query to build the 20 datasets and export them.   However, doing that manually doesn't seem very efficient and wouldn't be practical if there were 100 Regions, as there could be for other work I'm involved in.  There's also an issue if a new Region or Sector appears in the data in the future as a) I wouldn't know until someone spotted the mistake and b) it would need a manual intervention to fix the problem.  There must be a better way surely?   I basically want to run the export (in a Code Node?) so that it does something along the lines of:   For each Region, filter by Region and export, then next Region.   I've not used Code Nodes very much and I don't know if that's the best approach, but would appreciate some pointers before I head off down various rabbit warrens and blind alleys?   Thanks! ... View more

I have a large dataset that features multiple rows per User.  Each row has a date that corresponds to the period where data was collected from the user.  If the User stops needing to send data that ends up in this dataset the date column records 'END' rather than a date.  I odn't know why, but that's the way it is.   I want to use a computed column to recode the dates to return the date if there's a date, but if there isn't a date to return the latest date against the appropriate User.     I can do the CASE WHEN bit, but I don't know how to pick out the MAX date for each User?  I'm sure it's really easy, but I've not done it before and I'm struggling to know what to google for!   Any help would be appreciated!   Thanks   Paul. ... View more