I have a table of error logs streaming in within one table. I want to be able to click on a row within the table vis then drill through to the previous 50 entries (although I'd like to be able to adjust the number of entries within a parameter if possible) in another page.
So far I've tried indexing the column, selecting one (e.g RowID: 100) then creating a SelectedIndexMin (50) and SelectedIndexMax (100) field then created a WithinRange flag field (using an if statement) back into the original "Messages" table. I was hoping to drill down on the WithinRange field to take those 50 row ids through to another page, so far no good as the WithinRange shows a 1 for everything.
WithinRange = IF(AND(Messages[RowID]<=[SelectedIndexMax]
Any help would be greatly appreciated.
Values in a calculated column are fixed. They are an immutable result for each row in the table.