Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When we give 2 dimensions (Date and other) and 1 measure in Line Trend Chart, getting the issue like loosing the colors after selecting the date from filter pane. even after ignoring the date in set analysis
Line Chart dimensions and Measures are given below
Dimension 1 : MyDate
Dimension 2 : Country
Measure : Sum({<MyDate=, MyDate = {">=$(=AddMonths(Date(Max(MyDate)), -11))<=$(=Date(Max(MyDate)))"}>}MeasureValue)
Color setting : Auto
Typically this would be because the data is not associated with a valid date.
The set analysis does not ignore MyDate, It does nothing to set MyDate=, then MyDate={some set expression}. The set expression is absolute (unless -= is used).
Would need sample data to help further,