Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

If the crossing shelf contains two dimension values, the exposure is exposed to a meaningless sum or avg value. #971

Closed
Taehui opened this issue Nov 30, 2018 · 1 comment
Assignees
Labels
bug Something isn't working @chart Chart Component and Widget
Milestone

Comments

@Taehui
Copy link

Taehui commented Nov 30, 2018

Describe the bug

  • 라인차트의 교차선반에 Dimension 이 두개 이상 올라가는 경우, 의도하지 않은 SUM 또는 AVG 값이 Measure 값으로 차트에 표현됨

To Reproduce

Expected behavior

  • 의도하지 않은 값에 대한 표현 삭제

Desktop (please complete the following information):

  • OS: [e.g. iOS]
  • Browser [e.g. chrome, safari]
  • Version [e.g. 22]
@Taehui Taehui added the bug Something isn't working label Nov 30, 2018
@kyungtaak kyungtaak self-assigned this Dec 3, 2018
@kyungtaak kyungtaak added the @chart Chart Component and Widget label Dec 3, 2018
@kyungtaak kyungtaak modified the milestones: 3.1.0, 3.2.0 Dec 3, 2018
@juheeko9
Copy link
Contributor

@kyungtaak
라인차트에서 교차선반에 dimension을 2개이상 올렸을경우 리턴되는 데이터의 columns의 첫번째 값이 잘못된 데이터로 리턴됩니다. 확인 부탁드립니다.

[API]
POST api/datasources/query/search

[Request Body]
{"context":{"discovery.route.uri":"/workbook/5d22985e-80b5-4dae-b4ae-95ebdf977dfb","discovery.dashboard.id":"2ef9e1db-1a2f-4784-9c1b-cdf05706145d"},"userFields":[],"dataSource":{"joins":[],"temporary":false,"id":"ds-37","name":"sales","uiDescription":"sales data (2011~2014)","type":"default","connType":"ENGINE","engineName":"sales"},"filters":[],"pivot":{"columns":[{"type":"dimension","name":"Category","subType":"STRING","subRole":"DIMENSION","alias":"Category"}],"rows":[],"aggregations":[{"type":"measure","aggregationType":"SUM","name":"Discount","subType":"DOUBLE","subRole":"MEASURE","format":{"type":"number","sign":"KRW","decimal":2,"useThousandsSep":true,"abbr":"NONE","customSymbol":null},"alias":"SUM(Discount)"},{"type":"dimension","name":"Region","subType":"STRING","subRole":"DIMENSION","alias":"Region"},{"type":"dimension","name":"Country","subType":"STRING","subRole":"DIMENSION","alias":"Country"}]},"limits":{"limit":1000,"sort":[]},"aliases":[{"type":"value","ref":"2ef9e1db-1a2f-4784-9c1b-cdf05706145d"}],"resultFormat":{"type":"chart","mode":"line","options":{"addMinMax":true,"showCategory":true,"showPercentage":true,"isCumulative":false},"columnDelimeter":"―"}}

[Return]
{"rows":["Furniture","Office Supplies","Technology"],"categories":[{"name":"SUM(Discount)","value":[],"percentage":[]}],"columns":[{"name":"―SUM(Discount)","value":[368.89,947.8,244.39999999999998],"percentage":[23.63028396825295,60.713988303044665,15.655727728702379]},{"name":"Central―United States―SUM(Discount)","value":[143.03999999999996,359.4,55.89999999999999],"percentage":[25.618798581509473,64.36938066411147,10.011820754379052]},{"name":"East―United States―SUM(Discount)","value":[92.60000000000002,244.70000000000002,76.7],"percentage":[22.367149758454108,59.106280193236714,18.526570048309175]},{"name":"South―United States―SUM(Discount)","value":[40.35,166.60000000000002,31.6],"percentage":[16.914692936491303,69.8386082582268,13.246698805281913]},{"name":"West―United States―SUM(Discount)","value":[92.9,177.10000000000005,80.20000000000002],"percentage":[26.527698458023984,50.571102227298695,22.901199314677328]}],"info":{"maxValue":947.8,"minValue":31.6,"totalCategory":3}}

[참고화면]
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working @chart Chart Component and Widget
Projects
None yet
Development

No branches or pull requests

3 participants