Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can Some one help me with my Question below
I have Multiple Rows in table Box like below
ProjectID [Total Service Credit Balance in Hours] as Field Names
Project 1-- 280 Hours
project 1 -280 hours
Project 1--280 Hours
Project 2--156 Hours
Project 2 --156 Hours
Project 2--156 Hours
I want to value of both projects as 436 so i tried to write like below
=(AGGR(SUM(DISTINCT [Total Service Credit Balance in Hours]),[Project ID])) in Chart Properties expressions.
But it works when i select for single project ID in filters , and if i remove filter i am not getting any values in my Chart expressions.
Can some one help me here , Please Thanks.
Best Regards,
HK
May be Aggr inside sum. Like this?
SUM(AGGR([Total Service Credit Balance in Hours],[Project ID]))
I think that you have an issue with the data-quality and you should solve them first before trying to bypass them with complex expressions. In your case seems a data-cleaning within the script like this:
upper(trim(replace([Project ID], '--', '-'))) as [Project ID]
or maybe a mapping-solution for this suitable: Mapping … and not the geographical kind.
- Marcus
Works Fine for me?
As Marcus says, may be you have data quality issues in your Data Model? Pl share a sample so that we can better understand your problem?