yesterday's data
1 Topic
When appending data daily to a source file, how do I show a visual with data from only yesterday?
Session information for the last 24 hours (midnight to midnight) is extracted from Citrix VDI, and appended to a SQL table. I am working with that SQL table. I do have a simple date table as a dimension. Source data has Session StartDate and Session EndDate in it. If today is (for example), January 9th at 5pm, then the data that was last appended is the session information (start and end time, user name, and other metrics) for January 8th, from the beginning of the day to midnight January 8th (or 11:59:59). I append more data every day. I want to have a visual that shows (in my example) all of January 8th. How do I show only the latest day's data (January 8th in my example) in the visual (either a chart or a table)?Solved577Views0likes2Comments