Plum Insight Documentation
reporting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
reporting [2016/09/22 15:23]
admin [Survey Visits]
reporting [2018/06/27 11:08] (current)
admin
Line 148: Line 148:
  
 Questions of different question types cannot be merged. Any questions that are of the same question type can be merged, and any questions of the same question type that have the same question text and answer choices, as may be the case with multiple choice or multiselect questions, will be merged automatically. Questions of different question types cannot be merged. Any questions that are of the same question type can be merged, and any questions of the same question type that have the same question text and answer choices, as may be the case with multiple choice or multiselect questions, will be merged automatically.
 +
 +
 +====Translating Unix timestamps====
 +By default, all start and end times are recorded as Unix timestamps. This is a universal standard that accommodates all time zones. If you'd like to translate Unix timestamps into a more readable format, here's how:
 +
 +  - Open your report in Excel
 +  - Create a new column for your readable date, put in this formula: =(((**A1**/​60)/​60**-5**)/​24)+DATE(1970,​1,​1) where A1 is the column with the Unix timestamp, and -4 is the offset for GMT. For example, EST is -5 hours off from GMT, so this formula would provide the date in EST timezone. For GMT timezone, the formula would be <​code>​=(((A1/​60)/​60)/​24)+DATE(1970,​1,​1)</​code>​ For PST, the formula would be  <​code>​=(((A1/​60)/​60-8)/​24)+DATE(1970,​1,​1)</​code>​
 +  - Once you hit enter, you will notice a numeric value. Make sure you format that cell as a "​Date"​ and you may pick which date format you prefer.
 +
 +
reporting.txt · Last modified: 2018/06/27 11:08 by admin