update data format to pass to dashboard