Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In my scenario is it possible to ignore the selections of a field which has been used in grouping .
Any Suggestion on the requirement plz