Hi,
I need a quick help.
I am trying to create a Slice with a row filter expression. The Slice’s name is “Chart Slice” and it is based on a Table called “Full DB” which records a lot of patient details. This “Full DB” has a column called [OT Date] which records operation theatre dates for each patient. I want to isolate a set of rows based on this [OT Date] column’s dates. The dates will be determined by the user who fills out a form in a different table called “Analyser”. In this Analyser table, there are 2 columns called [OT Start Date] and [OT End Date]. When the user fills out this start and end dates and save the form, it creates a new row in this Analyser table. I just want the Slice (“Chart Slice”) to grab the values of [OT Start Date] and [OT End Date] from the Analyser table’s last filled row, and isolate the rows in the Full DB based on the [OT Date] column that has recorded dates lying between these values determined by the [OT Start Date] and [OT End Date].
Can anyone please help me?
Many thanks to you!
LinkedIn
Twitter
