4 Replies Latest reply: Jan 27, 2017 6:03 AM by kushal chawda RSS

    neglecting selections in a particular field without using set analysis?

    Divya anand

      I have created a bar chart in which [Month-Year] is the Dimension & the expression is as shown below-


      =Count(DISTINCT Aggr(If((STATUS<>'CNCL' AND COMPLETED >= MonthStart(Max(Date)) and Match(Type, 'Scheduled','Completed')),



      Now when a selection is made in the list box "Month", the data only with respect to that month is shown in this bar chart. How do I make any selections made in month/year/[Month-Year] not effect this chart?


      Using set analysis will work, but since I am using Aggr function here, not sure how to fit this in. Does anybody have an idea on this?


      Thank you.