{"action":"created","issue":{"url":"https://api.github.com/repos/metatron-app/metatron-discovery/issues/240","repository_url":"https://api.github.com/repos/metatron-app/metatron-discovery","labels_url":"https://api.github.com/repos/metatron-app/metatron-discovery/issues/240/labels{/name}","comments_url":"https://api.github.com/repos/metatron-app/metatron-discovery/issues/240/comments","events_url":"https://api.github.com/repos/metatron-app/metatron-discovery/issues/240/events","html_url":"https://github.com/metatron-app/metatron-discovery/issues/240","id":360611276,"node_id":"MDU6SXNzdWUzNjA2MTEyNzY=","number":240,"title":"Improve the Save data table action for useful download functions.","user":{"login":"Taehui","id":612173,"node_id":"MDQ6VXNlcjYxMjE3Mw==","avatar_url":"https://avatars2.githubusercontent.com/u/612173?v=4","gravatar_id":"","url":"https://api.github.com/users/Taehui","html_url":"https://github.com/Taehui","followers_url":"https://api.github.com/users/Taehui/followers","following_url":"https://api.github.com/users/Taehui/following{/other_user}","gists_url":"https://api.github.com/users/Taehui/gists{/gist_id}","starred_url":"https://api.github.com/users/Taehui/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Taehui/subscriptions","organizations_url":"https://api.github.com/users/Taehui/orgs","repos_url":"https://api.github.com/users/Taehui/repos","events_url":"https://api.github.com/users/Taehui/events{/privacy}","received_events_url":"https://api.github.com/users/Taehui/received_events","type":"User","site_admin":false},"labels":[{"id":1029637323,"node_id":"MDU6TGFiZWwxMDI5NjM3MzIz","url":"https://api.github.com/repos/metatron-app/metatron-discovery/labels/awaiting%20feedback","name":"awaiting feedback","color":"b4a4f2","default":false}],"state":"open","locked":false,"assignee":{"login":"AnnieHwang","id":6300003,"node_id":"MDQ6VXNlcjYzMDAwMDM=","avatar_url":"https://avatars3.githubusercontent.com/u/6300003?v=4","gravatar_id":"","url":"https://api.github.com/users/AnnieHwang","html_url":"https://github.com/AnnieHwang","followers_url":"https://api.github.com/users/AnnieHwang/followers","following_url":"https://api.github.com/users/AnnieHwang/following{/other_user}","gists_url":"https://api.github.com/users/AnnieHwang/gists{/gist_id}","starred_url":"https://api.github.com/users/AnnieHwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AnnieHwang/subscriptions","organizations_url":"https://api.github.com/users/AnnieHwang/orgs","repos_url":"https://api.github.com/users/AnnieHwang/repos","events_url":"https://api.github.com/users/AnnieHwang/events{/privacy}","received_events_url":"https://api.github.com/users/AnnieHwang/received_events","type":"User","site_admin":false},"assignees":[{"login":"AnnieHwang","id":6300003,"node_id":"MDQ6VXNlcjYzMDAwMDM=","avatar_url":"https://avatars3.githubusercontent.com/u/6300003?v=4","gravatar_id":"","url":"https://api.github.com/users/AnnieHwang","html_url":"https://github.com/AnnieHwang","followers_url":"https://api.github.com/users/AnnieHwang/followers","following_url":"https://api.github.com/users/AnnieHwang/following{/other_user}","gists_url":"https://api.github.com/users/AnnieHwang/gists{/gist_id}","starred_url":"https://api.github.com/users/AnnieHwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AnnieHwang/subscriptions","organizations_url":"https://api.github.com/users/AnnieHwang/orgs","repos_url":"https://api.github.com/users/AnnieHwang/repos","events_url":"https://api.github.com/users/AnnieHwang/events{/privacy}","received_events_url":"https://api.github.com/users/AnnieHwang/received_events","type":"User","site_admin":false}],"milestone":null,"comments":10,"created_at":"2018-09-16T07:06:42Z","updated_at":"2018-10-11T08:46:23Z","closed_at":null,"author_association":"COLLABORATOR","body":"**Is your feature request related to a problem? Please describe.**\r\n테스트 : https://discovery.metatron.app/app/v2/workbook/2462e00f-1043-4921-879f-a92dec6a00a7\r\n1. Metatron(클라우드) 에서 Sales 데이터로 워크북 생성\r\n2. Global 필터로 Order Date 필터링 적용\r\n3. 두개의 데이터 테이블 차트 생성 후, 차트필터로 Ship Mode 필터링 적용(두개 값만 멀티 선택)\r\n4. 두개의 차트 중 하나는 피봇으로, 하나는 오리지널로 뷰모드 변경\r\n\r\n![sales](https://user-images.githubusercontent.com/612173/45593747-eb2c9c80-b9c7-11e8-8428-49d98e047e76.png)\r\n![chart_filter](https://user-images.githubusercontent.com/612173/45593749-eec02380-b9c7-11e8-8ca4-27afc698a5af.png)\r\n\r\n대시보드 화면에서 각각 Save data table 액션 수행\r\n![download_pivot](https://user-images.githubusercontent.com/612173/45593769-5aa28c00-b9c8-11e8-97fa-df0d89cddcf4.png)\r\n![download_orignal](https://user-images.githubusercontent.com/612173/45593774-5d04e600-b9c8-11e8-8513-98dc59abe594.png)\r\n\r\n피봇 테이블과 오리지널 테이블 둘다 Download original data 만 가능하며, 다운로드 결과 데이터가 같음.\r\n\r\n**Describe the solution you'd like**\r\n사용자 입장에서는 첨부파일과 같은 2가지 유형의 다운로드가 필요함\r\n\r\n[expected_download.xlsx](https://github.com/metatron-app/metatron-discovery/files/2386367/expected_download.xlsx)\r\n\r\n- 엑셀시트 중 filtered data : 글로벌필터와 차트필터가 적용된 데이터(선반에 올려진 값과 상관없이 rawdata 에서 필터만 적용)\r\n- 엑셀시트 중 chart data : filtered data 에서 차트를 그리기 위해 선반에 올려진 값의 결과값 데이터\r\n\r\n현재 제공되는 Save data table 화면에서 표현되는 Csv, Excel 기능을 둘다 디폴트 값을 Excel 로 바꾸되, Chart Data, Filtered Data 로 변경\r\nExcel 혹은 Csv 는 별도 옵션으로 선택하여 다운로드\r\n\r\n**Describe alternatives you've considered**\r\nDatasource 화면에서 다운로드 기능으로 보완 가능하나,\r\n![datasource](https://user-images.githubusercontent.com/612173/45593867-5d05e580-b9ca-11e8-83b1-cc463ef8ed6c.png)\r\n\r\n이 화면에서는 Data Source 에 등록된 Rawdata 를 보여주는 것이 필요해 보이므로 현재 기능을 유지하되, \r\n가장 최근 데이터가 표현되었으면 좋을 듯 하며, Datetime 정보를 필터링(From, To 날짜시간선택) 하여 필터링 된 양(row number or size) 을 제공하여 사용자가 다운로드 받을 수 있도록 제공\r\n또한 다운로드 버튼이 좀더 강조(엑셀 아이콘등) 되었으면 함\r\n\r\n**Additional context**\r\nIDCube\r\n"},"comment":{"url":"https://api.github.com/repos/metatron-app/metatron-discovery/issues/comments/428872817","html_url":"https://github.com/metatron-app/metatron-discovery/issues/240#issuecomment-428872817","issue_url":"https://api.github.com/repos/metatron-app/metatron-discovery/issues/240","id":428872817,"node_id":"MDEyOklzc3VlQ29tbWVudDQyODg3MjgxNw==","user":{"login":"AnnieHwang","id":6300003,"node_id":"MDQ6VXNlcjYzMDAwMDM=","avatar_url":"https://avatars3.githubusercontent.com/u/6300003?v=4","gravatar_id":"","url":"https://api.github.com/users/AnnieHwang","html_url":"https://github.com/AnnieHwang","followers_url":"https://api.github.com/users/AnnieHwang/followers","following_url":"https://api.github.com/users/AnnieHwang/following{/other_user}","gists_url":"https://api.github.com/users/AnnieHwang/gists{/gist_id}","starred_url":"https://api.github.com/users/AnnieHwang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AnnieHwang/subscriptions","organizations_url":"https://api.github.com/users/AnnieHwang/orgs","repos_url":"https://api.github.com/users/AnnieHwang/repos","events_url":"https://api.github.com/users/AnnieHwang/events{/privacy}","received_events_url":"https://api.github.com/users/AnnieHwang/received_events","type":"User","site_admin":false},"created_at":"2018-10-11T08:46:23Z","updated_at":"2018-10-11T08:46:23Z","author_association":"CONTRIBUTOR","body":"@Taehui 저 위의 질문하신게, 혹시 데이터소스 다운로드 관련 건수 제한인가요? 그럼 현재 그렇게 구현되고 있는 상태입니다. 걱정안하셔도... 만약 차트의 데이터 건수제한이라면, 저희가 조만간 Limit기능을 다시 재오픈할 예정입니다. 참고부탁드립니다.\r\n\r\n@minjung-cho 개발쪽과 기획안 논의를 했는데, 아래내용 적용 부탁드려요. \r\n1. 대시보드 상 원본보기에서는 'Apply filters' 기능을 삭제해주시고, 시간 구간 UI로 원본데이터를 보고 다운로드받을 수 있게 수정부탁드립니다. (default는 전체 시간 범위입니다)\r\n2. 차트 위젯 내 다운로드 시 원본데이터는 선반에 올라기 있는 컬럼들에 대해서만 보여집니다.\r\n3. 위 내용 디자인 진행 부탁드립니다."}}
{"actor":{"display_login":"AnnieHwang"}}