Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The code below gives me the required points on a line chart, but is still impacted by users selecting 1 month from Mth-Yr for example, and then the chart will only show that point. How do I change it to ignore user selections for all the condition fields below? thanks
Avg(Aggr(Max({$<[Journey_part]={"Overall Response"},[Colour]={'Red','Purple'},WrpCouncil={'Masterton'},[Mth-Yr]={'>=$(=v13MthsAgo)'} >}Duration),Ref_Number))
Hi @guster999
Try like below
Avg({1}Aggr(Max({1<[Journey_part]={"Overall Response"},[Colour]={'Red','Purple'},WrpCouncil={'Masterton'},[Mth-Yr]={'>=$(=v13MthsAgo)'} >}Duration),Ref_Number))
If v13MthsAgo variable is dynamic, you need to set {1} for this variable also.
So, based on above , we can ignore the user selection
{1} <-- ignore all the selections
Hi @guster999
Try like below
Avg({1}Aggr(Max({1<[Journey_part]={"Overall Response"},[Colour]={'Red','Purple'},WrpCouncil={'Masterton'},[Mth-Yr]={'>=$(=v13MthsAgo)'} >}Duration),Ref_Number))
If v13MthsAgo variable is dynamic, you need to set {1} for this variable also.
So, based on above , we can ignore the user selection
{1} <-- ignore all the selections
Many thanks, that works perfectly😊