Need Help to ignore only Date Selection for KPI

[manojkulkarni]

Hello All,

I have one KPI and bar chart to show bug burndown chart which is working as expected. I am facing the issue when someone makes selection of dates in bar chart, above KPI value also changes to respect to the selection made which is correct and fine. But the requirement is to ignore the date selection alone while calculating the KPI values. KPI values are based on current date. I have copied the expression used for KPI and dimensions used in Bar chart. Kindly suggest how this can be achieved.

KPI Formula: ( 2 Weeks Avg)

Avg( AGGR( Rangesum(

Count(Distinct {<State-={'Closed','Removed'}, Type={'Bug'},

WeekStart={">=$(=weekstart(today()-14)) <= $(=weekstart(Today()-7))"}>}

BugID)),WeekStart))

Bar Chart :

Dimension - DayMonthYear

Expression - Count({<State-={'Closed','Removed'}>}BugID)

DimDate: (Table used in data model)

DayMonthYear

WeekStart

WeekEnd

[Mark_Little]

HI @manojkulkarni 

Just need to add the field you want to ignore to your set analysis. Something like this

Avg( AGGR( Rangesum(

Count(Distinct {<Date,State-={'Closed','Removed'}, Type={'Bug'},

WeekStart={">=$(=weekstart(today()-14)) <= $(=weekstart(Today()-7))"}>}

BugID)),WeekStart))

[vinieme12]

simply ignore your  datefield in all aggregation functions

Avg( {<Datefield=>}

AGGR({<Datefield=>} Rangesum(

Count(Distinct {<Datefield=,State-={'Closed','Removed'}, Type={'Bug'},

WeekStart={">=$(=weekstart(today()-14)) <= $(=weekstart(Today()-7))"}>}

BugID)),WeekStart))

[manojkulkarni]

@MarkS ,

I have already used date related fields in Set to ignore the selection but still not working. Is it because i am also using WeekStart to filter the data ?

[manojkulkarni]

Hi @vinieme12 

I have tried using date related fields in all Aggregation functions to ignore the selection but still not working. 

[vinieme12]

do you have any calculated dimensions in the chart?

[manojkulkarni]

Hi @vinieme12 ,

don't have any calculated dimensions

[vinieme12]

can you post the exact expression used after adding the fields to ignore