topic Re: Issue with 100% Bar Chart in App Development

Issue with 100% Bar Chart

CaseySBS — Tue, 28 Jun 2022 16:55:36 GMT

Greetings,

I've been having an issue related to a 100% stacked bar chart. Essentially, I'm taking several related SQL tables in order to pull in the square footage of facilities, then classifying their units by occupancy status. However, as you can see below, the percentages are coming back well over 100%. I think there may be an issue with the formula, but I'm unsure. Can anyone help? Formula is:

SUM([Square Ft])/SUM(total <[LastDayOfMonth-unu_dtm_Datetime.autoCalendar.YearMonth]> ([Square Ft]))

Re: Issue with 100% Bar Chart

sidhiq91 — Tue, 28 Jun 2022 17:08:08 GMT

@CaseySBS Could you please provide us with some sample data? I will see if I could resolve the issue for you.

Re: Issue with 100% Bar Chart

CaseySBS — Tue, 28 Jun 2022 18:10:29 GMT

Sure, I can do that. Would a workbook of some of the table data work? I'm also pasting the table relationship layout below.

Re: Issue with 100% Bar Chart

sidhiq91 — Wed, 29 Jun 2022 04:15:05 GMT

@CaseySBS Yes Please attach the Excel Sheet of your table data. Thanks.

Re: Issue with 100% Bar Chart

CaseySBS — Wed, 29 Jun 2022 14:53:12 GMT

No problem, attached you'll find samples of the relevant tables.

Thank you