Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a gauge chart on my dashboard and a listbox . i don't want the list box Process selection to impact the values of gauge chart .
i have tried the Process= in the set analysis in my expression but still the values got changed
Any suggestion
=if(Count({$<[outage_type]={1},gc_rec_ID={692},Link_Flag={'Spectrum'},Process=>} DISTINCT model_outage_id)>0,
(Count({$<gc_rec_ID={692},outage_type={0},Link_Flag={'Spectrum'},Process=>} DISTINCT model_key)
- Count({$<gc_rec_ID={692},Link_Flag={'Spectrum'},outage_type={1},Process=>} DISTINCT model_key) +
Sum({$<[outage_type]={1},gc_rec_ID={692},Link_Flag={'Spectrum'},Process=>} Aggr(1- Num((Sum({$<[outage_type]={1},gc_rec_ID={692},Link_Flag={'Spectrum'},Process=>} duration_sec)/Num#(Interval(MonthEnd([Call_Year-Month])-MonthStart([Call_Year-Month]),'ss'))),'####.#####'),model_key)))
/Count({$<gc_rec_ID={692},outage_type={0},Link_Flag={'Spectrum'},Process=>} DISTINCT model_key)
,1)
i think this is because of the below part which is not under set analysis
Num#(Interval(MonthEnd([Call_Year-Month])-MonthStart([Call_Year-Month]),'ss'))),'####.#####')
The selection of Process is probably limiting the possible values of model_key, which is the dimension in your Aggr() expression and that is affecting the output of your expression. Unfortunately there is no easy set expression workaround.
Yes but i am looking for any other solution .. is there any other way without changing anything in the expression
Cant really say without a sample qvw document that illustrates the problem. May also need source data (or inline loads) so that someone can look at modifications to your data model to avoid the Aggr() expression.