Can you create an inline table using an expression.
I have two tables: PatientVisit and CalendarDate. PatientVisit has PatientID AdmitDate and DischageDate. I have a chart that shows how many hours patiends were in the hospital on each day. This chart can take a lone time to refresh if I make a selection. I would like to do the calculation of these days during reload to improve response time on the chart when the end users are viewing it. Is it possible to use an expression in the load script to do this. Where do I start?
Please see attached qvw. For this stripped down example I am using an inline table for PatientVisits.