100% Stack Column Chart Display Issue

matthewlau120 — Mon, 11 Mar 2019 10:06:58 GMT

Hi All,

I have a question about the display of the 100% stack column chart. Why would the entity "FW" shown in 100% but the x axis still have 150% ? In Alternative, I have choose another entity "HC" shown in 100% but don't have this issue.

Kindly attach for the screenshot and set analysis equation:

Equation: (Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}Productnetamount)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}[sales_details.disc_amt])
-Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}amt)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}cdisc_amt)
+Sum({$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]-={"PREPAID_****"}>}[sales_details.disc_amt])
+Sum({$-<[check_time.autoCalendar.Date]={'$(=date(max([check_time])))'},[sales_details.status]={"0"},[sales_details.item_code]={"*"}>}[sales_details.disc_amt]))
/(Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}Productnetamount)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}[sales_details.disc_amt])
-Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]={"PREPAID_****"}>}amt)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"}>}cdisc_amt)
+Sum(total<Day>{$<[check_time.autoCalendar.Year]={'$(=year(max([check_time])))'},[sales_header.status]={"0"},[sales_details.item_code]-={"PREPAID_****"}>}[sales_details.disc_amt])
+Sum(total<Day>{$-<[check_time.autoCalendar.Date]={'$(=date(max([check_time])))'},[sales_details.status]={"0"},[sales_details.item_code]={"*"}>}[sales_details.disc_amt]))

Screenshot (HC)

topic 100% Stack Column Chart Display Issue in App Development

100% Stack Column Chart Display Issue