Issue with total %

[#1]

Hi sunindia‌

I'm having issue with one of my chart when I'm showing it in %.

If you see the legend is showing 6 values but the chart shows only two. And even the percentage in the chart is not matching even for those two as well.

We are having the issue because records are in multiple buckets.

I mean the individual record has a value in ACH as well as in other FMX as well on a particular day,

Exp:

sum({<Year=,TRANSACTION_DATE={'>=$(=Monthstart(AddMonths(max(TRANSACTION_DATE),-15)))'}>} NTPV_AMT) /

sum({<Year=,TRANSACTION_DATE={'>=$(=Monthstart(AddMonths(max(TRANSACTION_DATE),-15)))'}>} TOTAL <Month> NTPV_AMT)

Regards,

Sachin

[sunny_talwar · Accepted solution]

If I remove Week and Week of Year from dimension, I am seeing this:

..

Your screenshot from the previous post did not seem to include those two as dimension

[#3]

Hi Sunny,

But it doesn't seem to work for other date dimensions?

[swuehl]

I believe the issue is in your data model, see for example

TRANSACTION_DATE	FMX	Sum(NTPV_AMT)
1/3/2016	ACH	114,02
	BAL	1003,02
	CREDCARD	1003,02
	DEBCARD	1003,02
Total		1003,02

The expression total for that date does not sum up the rows. I would suggest you recheck the logic between your Transactions and Summary table.

Or maybe consider using a sum-of-rows using advanced aggregation.

Hope this helps,

Stefan

P.S. and please close the other thread...

[swuehl]

If you want to continue in a private discussion with Sunny, that's ok, but I would suggest that you close your public threads then.