Export Length of Event Data - Printable Version +- Apnea Board Forum - CPAP | Sleep Apnea (https://www.apneaboard.com/forums) +-- Forum: Public Area (https://www.apneaboard.com/forums/Forum-Public-Area) +--- Forum: Software Support Forum (https://www.apneaboard.com/forums/Forum-Software-Support-Forum) +--- Thread: Export Length of Event Data (/Thread-Export-Length-of-Event-Data)

Export Length of Event Data - jdavidstark - 06-18-2022 Is or could there be a way to export from OSCAR length-of-event data? When I mouse over a given event in OSCAR, a box comes up with a description of the event and what appears to be an indication of the length of the event (in seconds?). I'd like to be able to export this length-of-event data so I can aggregate it and have a closer look at what pressure/range of pressures I'm most likely to have the least time in the night that I'm spending in events. I've tried to manipulate the data already in the details export to supply this information, but the best I've been able to do for an "end point" to the event is the next pressure change--which of course might well be later than the event actually lasted if the machine doesn't immediately think it needs to change the pressure in response. Thanks so much for your thoughts on this question! RE: Export Length of Event Data - Crimson Nape - 06-18-2022 Hi jdavidstark!  -   First, go to the Daily screen and select the Events tab on the left side.  This will list all events and, by expanding the event type, will show the time it occurred and the length in seconds in parentheses.   Hypopneas do not have a length report by the CPAP, thus none will be listed on the report. To export these events, go to File ⇾ Export Data ⇾ CSV Export Wizard.  In the Quick Range, select the day you wish to pull the data.  Set the Resolution option to Details.  Select a location to create this file, then select the Export. To forewarn you, the data you seek is buried in this file.   Open the file in your favorite spreadsheet program, selecting the comma (,) as the field separator. The 3rd column, "Event", will have the name of the event type you are looking for.   I've found it easier to sort the data using this column for the sort criteria.   This will alphabetize both the events you are looking for and, all the ones you don't.  Grouping the events by type will allow you the option to delete the unwanted ones easier. - Red RE: Export Length of Event Data - jdavidstark - 06-18-2022 Thanks for that input. I am able to do the details export as you suggest, and I hadn't noticed that hypopneas don't have lengths reported. So, that's helpful to know. But what I seem to be missing from the details export is the lengths of the other kinds of events. Is it possible to include that data in the export somehow? Thanks, again! RE: Export Length of Event Data - jdavidstark - 06-18-2022 Sorry--my bad. I think I see now how the Data/Duration column gives me both pressures when there's a change and the length of the event when that's applicable. Thanks so much! RE: Export Length of Event Data - Crimson Nape - 06-18-2022 You've done well, Grasshopper! RE: Export Length of Event Data - jdavidstark - 06-18-2022 Thanks! ;-) And I think part of my issue was that I had a bunch of Dreamstation 1 data at the beginning of the export. But it looks like the Dreamstation 1 doesn't tag event length, so that field was just coming up as all zeros until I got to the Airsense 10 section. :-P Appreciate your help!