{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":806763001,"defaultBranch":"main","name":"DataDiary","ownerLogin":"OsamaKhanMarwat","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2024-05-27T21:12:48.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/91750824?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1716844369.0","currentOid":""},"activityList":{"items":[{"before":"925848187a066598037ce3801c2b79256c615021","after":"0d697cbaa4b06aad41fcbf34405318f1257f222d","ref":"refs/heads/main","pushedAt":"2024-05-29T12:01:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Excel Data","shortMessageHtmlLink":"Excel Data"}},{"before":"a4f2dfc06cad36331b962d0fe012e592e767314a","after":"925848187a066598037ce3801c2b79256c615021","ref":"refs/heads/main","pushedAt":"2024-05-29T11:59:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Delete Pivot Table/Screenshot","shortMessageHtmlLink":"Delete Pivot Table/Screenshot"}},{"before":"e56de17dd1afc53e96ca895a6f52be7ab557d1c0","after":"a4f2dfc06cad36331b962d0fe012e592e767314a","ref":"refs/heads/main","pushedAt":"2024-05-28T07:49:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Add files via upload\n\nTransformed Pivot Tables","shortMessageHtmlLink":"Add files via upload"}},{"before":"f95ad968a84a856d71b4a8a64284760d4d96b25c","after":"e56de17dd1afc53e96ca895a6f52be7ab557d1c0","ref":"refs/heads/main","pushedAt":"2024-05-28T07:46:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"42126dd644f805cb0ff237533684e225ea4c1841","after":"f95ad968a84a856d71b4a8a64284760d4d96b25c","ref":"refs/heads/main","pushedAt":"2024-05-28T07:46:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Create README.md","shortMessageHtmlLink":"Create README.md"}},{"before":"a058001640cf8fd29d5fc754fffdd9cd2c099cd1","after":"42126dd644f805cb0ff237533684e225ea4c1841","ref":"refs/heads/main","pushedAt":"2024-05-28T07:42:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Delete Screenshot","shortMessageHtmlLink":"Delete Screenshot"}},{"before":"07613677669c1c15d0abacc2b41f70437487cd2e","after":"a058001640cf8fd29d5fc754fffdd9cd2c099cd1","ref":"refs/heads/main","pushedAt":"2024-05-28T07:41:19.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Create Screenshot","shortMessageHtmlLink":"Create Screenshot"}},{"before":"a2912d459426bdfea5726850bb0facfc0172062c","after":"07613677669c1c15d0abacc2b41f70437487cd2e","ref":"refs/heads/main","pushedAt":"2024-05-28T07:40:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Create Screenshot","shortMessageHtmlLink":"Create Screenshot"}},{"before":"6785f9a89b98d3d28171595901c40a983b922bad","after":"a2912d459426bdfea5726850bb0facfc0172062c","ref":"refs/heads/main","pushedAt":"2024-05-28T07:33:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Update ReadMe.md","shortMessageHtmlLink":"Update ReadMe.md"}},{"before":"c126a22f87e4da9e4f0c6167036916cecbf87861","after":"6785f9a89b98d3d28171595901c40a983b922bad","ref":"refs/heads/main","pushedAt":"2024-05-28T07:32:53.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Update ReadMe.md","shortMessageHtmlLink":"Update ReadMe.md"}},{"before":"cf98c074fdac716e8a3bfdecd20f15fb0084a2db","after":"c126a22f87e4da9e4f0c6167036916cecbf87861","ref":"refs/heads/main","pushedAt":"2024-05-28T07:27:09.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Update ReadMe.md","shortMessageHtmlLink":"Update ReadMe.md"}},{"before":"3598307e5e5c14203b19cd2d3381a2b3eae3c132","after":"cf98c074fdac716e8a3bfdecd20f15fb0084a2db","ref":"refs/heads/main","pushedAt":"2024-05-28T07:14:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Create ReadMe.md","shortMessageHtmlLink":"Create ReadMe.md"}},{"before":"74204d55d639979ba9fcb19846c1346053397dd4","after":"3598307e5e5c14203b19cd2d3381a2b3eae3c132","ref":"refs/heads/main","pushedAt":"2024-05-28T07:11:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Delete Pivot Table/pivot_video","shortMessageHtmlLink":"Delete Pivot Table/pivot_video"}},{"before":"76e3377e56045bf5037c46691beeac795673f174","after":"74204d55d639979ba9fcb19846c1346053397dd4","ref":"refs/heads/main","pushedAt":"2024-05-28T07:10:49.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Add files via upload\n\nTransform Your Pivot Tables - 8 Design Tips to Impress Anyone","shortMessageHtmlLink":"Add files via upload"}},{"before":"f1ce662400b63a2f979f199f64e8c7299a4fa4e4","after":"76e3377e56045bf5037c46691beeac795673f174","ref":"refs/heads/main","pushedAt":"2024-05-28T06:44:25.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Create pivot_video","shortMessageHtmlLink":"Create pivot_video"}},{"before":"a9461aae4953b99366d5b3a84ceac1ac8560193d","after":"f1ce662400b63a2f979f199f64e8c7299a4fa4e4","ref":"refs/heads/main","pushedAt":"2024-05-28T06:43:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Delete Pivot Table/pivot_video","shortMessageHtmlLink":"Delete Pivot Table/pivot_video"}},{"before":"1468a098c4eb75455899c10337df595cdc7c2f9f","after":"a9461aae4953b99366d5b3a84ceac1ac8560193d","ref":"refs/heads/main","pushedAt":"2024-05-28T06:41:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Create pivot_video","shortMessageHtmlLink":"Create pivot_video"}},{"before":"91cb8509ec852246368421a4acbade6fc0aecbc2","after":"1468a098c4eb75455899c10337df595cdc7c2f9f","ref":"refs/heads/main","pushedAt":"2024-05-28T06:40:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Delete README.md","shortMessageHtmlLink":"Delete README.md"}},{"before":"931337122ee09b3b807b1bbd21d9dc9794598355","after":"91cb8509ec852246368421a4acbade6fc0aecbc2","ref":"refs/heads/main","pushedAt":"2024-05-28T06:39:28.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Delete Pivot Table Video.mp4","shortMessageHtmlLink":"Delete Pivot Table Video.mp4"}},{"before":"adcd512dbbf59012b8f7af4e3fdb6ed6bd036e74","after":"931337122ee09b3b807b1bbd21d9dc9794598355","ref":"refs/heads/main","pushedAt":"2024-05-28T06:39:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Delete Pivot Table","shortMessageHtmlLink":"Delete Pivot Table"}},{"before":"fe1e019c56533626d717f3ad527311e2ea3032a4","after":"adcd512dbbf59012b8f7af4e3fdb6ed6bd036e74","ref":"refs/heads/main","pushedAt":"2024-05-27T21:53:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Pivot Table\n\nTransform Your Pivot Tables: 8 Design Tips to Impress Anyone :)\r\n\r\nPivot tables are a powerful tool for data analysis, but let's be honest—Excel's default pivot tables often look bland and uninspiring. If you want your pivot tables to stand out and impress, follow these eight design tips:\r\n\r\n1)  Clean Up Field Names: Remove prefixes like \"Sum of\" for clear, concise names.\r\n2)  Preserve Formatting on Refresh: Keep your custom formatting intact when updating data.\r\n3)  Add Spaces and Subtotals: Improve readability by breaking up data with spaces and subtotals.\r\n4)  Remove Filters: Streamline your pivot table by eliminating unnecessary filters.\r\n5)  Address Blank Cells: Fill in or remove blanks to maintain a clean look.\r\n6)  Create Stunning Templates: Develop reusable templates for consistent and attractive pivot tables.\r\n7)  Utilize Timelines: Make time-based data analysis easier with interactive timelines.\r\n8)  Apply Conditional Formatting: Highlight key data points to make important information stand out.\r\n\r\nBonus Tip: Add a Final Touch of Excellence\r\nIncorporate custom-calculated fields or slicers for deeper insights and interactivity.","shortMessageHtmlLink":"Pivot Table"}},{"before":"bb86c70b2037de730aa09a353b2771a6b936dadd","after":"fe1e019c56533626d717f3ad527311e2ea3032a4","ref":"refs/heads/main","pushedAt":"2024-05-27T21:46:51.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"README.md","shortMessageHtmlLink":"README.md"}},{"before":"44498894e635822a6377342a3517f4ad9bae329a","after":"bb86c70b2037de730aa09a353b2771a6b936dadd","ref":"refs/heads/main","pushedAt":"2024-05-27T21:42:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Pivot Table","shortMessageHtmlLink":"Pivot Table"}},{"before":"fb083d1bcd8a590c4d84c610e9df309cdd31047c","after":"44498894e635822a6377342a3517f4ad9bae329a","ref":"refs/heads/main","pushedAt":"2024-05-27T21:17:43.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"README.md","shortMessageHtmlLink":"README.md"}},{"before":null,"after":"fb083d1bcd8a590c4d84c610e9df309cdd31047c","ref":"refs/heads/main","pushedAt":"2024-05-27T21:12:49.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"OsamaKhanMarwat","name":"Osama Khan","path":"/OsamaKhanMarwat","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/91750824?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEVuQOMwA","startCursor":null,"endCursor":null}},"title":"Activity · OsamaKhanMarwat/DataDiary"}