topic Re: 100% stacked graph from a percentage stacked graph in App Development

100% stacked graph from a percentage stacked graph

vvvvvvizard — Wed, 22 Dec 2021 16:05:30 GMT

sum({<FIN_YR_NO = {"<=$(vMaxFinYr)"}, MTH_SHORT_DESC=>}$(vMeasure_FieldName))
/
sum({<FIN_YR_NO = {"<=$(vMaxFinYr)"},Milestone={'Intake'}, MTH_SHORT_DESC=>}$(vMeasure_FieldName))

Good day

Below is my expression for a % stacked graph , how do i convert this graph into a 100% stacked graph ?

Re: 100% stacked graph from a percentage stacked graph

JordyWegman — Tue, 04 Jun 2019 10:50:32 GMT

Hi,

You need TOTAL for this. Check this video.

Jordy

Climber

Re: 100% stacked graph from a percentage stacked graph

vvvvvvizard — Tue, 04 Jun 2019 11:00:32 GMT

I had many other graphs that were just numbers , i did use total<yr_mth_no> eg it works easily , the problem is this graph is already in percentages and the total <> is not working

Re: 100% stacked graph from a percentage stacked graph

JordyWegman — Tue, 04 Jun 2019 11:04:35 GMT

What is the dimension you are using in your graph? You need to include this in your set analysis.

Jordy

Climber

Re: 100% stacked graph from a percentage stacked graph

vvvvvvizard — Tue, 04 Jun 2019 11:26:19 GMT

TOTAL <YR_MTH_NO, FIN_YR_NO, MTH_SHORT_DESC, FIN_QTR_NO,Fiscal_Year,Fiscal_YearHalf,Fiscal_Quater,Cal_Day,WEEKNUM,WEEKLABEL,Date, Cal_YearMonth, Cal_DayName>$(vMeasure_FieldName)),

Re: 100% stacked graph from a percentage stacked graph

JordyWegman — Tue, 04 Jun 2019 11:48:45 GMT

Your results should in the following syntax:

Sum($(vMeasure_FieldName)) / Sum( TOTAL < [YourDimensionInBarChart] >$(vMeasure_FieldName))

You can expand the part before and after the / . But this is how you will get the 100% stacked charts.

Jordy

Climber

Re: 100% stacked graph from a percentage stacked graph

vvvvvvizard — Tue, 04 Jun 2019 17:17:42 GMT

Make the attachment a 100% stacked graph

Re: 100% stacked graph from a percentage stacked graph

JordyWegman — Tue, 04 Jun 2019 18:19:27 GMT

See the attachment. I've added another formula as test and added a type so you can clearly see the difference.

Jordy

Climber

Re: 100% stacked graph from a percentage stacked graph

vvvvvvizard — Tue, 18 Jun 2019 12:56:08 GMT

What happens if this my formula

(Sum(Contribution) * Sum(GL_VALUE) / count(DISTINCT Cost_Centre)) / count(distinct YR_MTH_NO)

How do i get 100% stacked i tried

YR_MTH_NO is my dimension

Re: 100% stacked graph from a percentage stacked graph

vvvvvvizard — Tue, 18 Jun 2019 13:09:27 GMT

(Sum(Contribution)/Sum(TOTAL <YR_MTH_NO> Contribution))
* (Sum(GL_VALUE)/Sum(TOTAL <YR_MTH_NO> GL_VALUE))
/ (count(DISTINCT Cost_Centre) / Count (DISTINCT TOTAL <YR_MTH_NO> Cost_Centre))
/ (count(distinct YR_MTH_NO)/(count(TOTAL <YR_MTH_NO> distinct YR_MTH_NO))
)