Need to Keep Count and Data Same what is seen for a particular category when category selection is done or not

[vvira1316]

Hi,

I've included sample data file and app.

Question is about the KPI 654, Data Table, Bar Chart included in the screen shots.

There 654 records in data table, bar chart.. In this 148 OFFNM1 records are there. Now if OFFNM1 is selected I should get same 148 count and records. Instead I'm getting 182. What changes I need to make to get same count and same records in detail, bar and KPI.

Following discussion links were related to same application.

In following calculations I've to exclude OSN value OSN1.

=Aggr(If(Max([DATE]) <= Today() - 30 and not

(

(FirstSortedValue(OFFNM, -[DATE]) = 'Basic' and FirstSortedValue(OSN, -[DATE]) >= '3')

or (FirstSortedValue(OFFNM, -[DATE]) = 'Basic Plus' and FirstSortedValue(OSN, -[DATE]) >= '5')

or (FirstSortedValue(OSN, -[DATE]) = '8')

or (FirstSortedValue(BlockerStatusName, -[DATE]) >= '2')

)

, DIM_FLD1_Id), DIM_FLD1_Id)

=Count(DISTINCT {<DIM_FLD1_Id = {"=Max([DATE]) <= Today() - 30 and not

(

(FirstSortedValue(OFFNM, -[DATE]) = 'Basic' and FirstSortedValue(OSN, -[DATE]) >= '3')

or (FirstSortedValue(OFFNM, -[DATE]) = 'Basic Plus' and FirstSortedValue(OSN, -[DATE]) >= '5')

or (FirstSortedValue(OSN, -[DATE]) = 😎

or (FirstSortedValue(BlockerStatusName, -[DATE]) >= '2')

)

"}>} DIM_FLD1_Id)

[vvira1316]

Hi,

Following expression I'm using in detail table, it is providing correct count but it shows records with value 0 / 1. Thevalue with 1 only is what have to be seen, how can I change it to count function

=Sum( {<OSN-={"OSN1"}>} Aggr(If(Max({1} TOTAL <DIM_FLD1_Id> [Data Date]) = [Data Date], 1, 0), DIM_EAI_Id, [Data Date]))

The other expression in another detail table is as follows, it also show records with value 0 / 1, and only records with 1 should be seen

=Sum(  Aggr(If(Max({1} TOTAL

<DIM_FLD1_Id> [Data Date]) <= Today() - 30 and Max({1}TOTAL<DIM_FLD1_Id> [Data Date]) > Today() - 60 and not

(
(FirstSortedValue(OFFNM, -[Data Date]) = 'OFFNM1' and FirstSortedValue(OSN, -[Data Date]) >= '3')
or (FirstSortedValue(OFFNM, -[Data Date]) = 'OFFNM2' and FirstSortedValue(OSN, -[Data Date]) >= '5')
or (FirstSortedValue(OSN, -[Data Date]) = '8')
or (FirstSortedValue(BSN, -[Data Date]) >= '2')
)

and Max({1}TOTAL <DIM_FLD1_Id> [Data Date]) = [Data Date], 1, 0), DIM_FLD1_Id, [Data Date]))

Please note that "Include Zero Values" flag is unchecked in both table.

Any help/guidnace.

Thanking you in advance.

BR,

Vijay

[rubenmarin]

Hi Vijay, sorry but I'm lost in what you are doing, can you post a sample telling wich value is worng and what value is expected?

[vvira1316]

Hi Ruben,

I'll be closing this thread and have opened another thread explaining the issue. Please refer to that thread.

Managing which records are visible in detail table (Extn of question in discussion 312668)

Thanks for all your help.

BR,

Vijay