how to Ignore the current selection

kunkumnaveen — Fri, 02 Apr 2021 08:15:38 GMT

Hi,

In below screen, the left chart(Pivot Chart) shows Dealer ,base model(FA) level Number of days and the right charts shows all the number of days greater that 30(Blue)

Number of days Expression:

(
sum(total<Year,Month,base_model,Dealer_Deal_Stock>mat_count)
/
alt(
avg({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}
aggr(
Sum({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}billing_count)
,Year,Month,base_model,Dealer_Deal_Stock)
),0)

) *30

I have used same expression in left side charts Dimension to get only those Dealers whose Number of days is >30.

Left chart Dimension:

=aggr(
if(
(
sum(total<Year,Month,base_model,Dealer_Deal_Stock>mat_count)
/
alt(
avg({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}
aggr(
Sum({<Year,Month,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}billing_count)
,Year,Month,base_model,Dealer_Deal_Stock)
),0)) *30>30,
Dealer_Deal_Stock),Dealer_Deal_Stock)

The requirement is when ever i select something from Dealer_Deal_Stock from left chart ,the selection should not show the impact on right hand side chart .which is not happening ,how to disable only Dealer_Deal_Stock selection

Note: Only Deal_Deal_Stock selection should not impact on right side chart the other fields selection should change the chart

Thanks

Re: how to Ignore the current selection

kunkumnaveen — Wed, 15 Jan 2020 10:15:35 GMT

In my scenario is it possible to ignore the selections of a field which has been used in grouping .

Re: how to Ignore the current selection

kunkumnaveen — Wed, 15 Jan 2020 12:50:52 GMT

Any Suggestion on the requirement plz

topic Re: how to Ignore the current selection in App Development

how to Ignore the current selection

Re: how to Ignore the current selection

Re: how to Ignore the current selection