Chart Line Style

[#1]

Hi,

I created a line chart with:

• Dimensions:
  • Month
  • Metric_Type & ' - ' & Product
• Expression:
  • =Sum({<Year=, Month=, Year_Month={">=$(=Max(Year_Month)-99) <=$(=Max(Year_Month))"}>}Values)
  • I use this expression so the chart can show the last 12 months (select Year and Month included)
    

I want to format the "Line Style" of the Expression for the different Metric_Type (SO or SI) using:

• =if(Metric_Type='SI', '<S1>', '<S3>')
  

But it doesn't work!!!

But If I use an Expression without Set Analysis like:

     =Sum(Values)

It Works!

Any Suggestions??

Thanks in advance,

Francisco

[Anonymous]

Hi Francesco,

How did you make Month and Year fixed and cannot be cleared from current selections. I thought this is a trigger but I didn't find any actions in your application. Can you explain this please.

Thanks and regards

[#3]

Hi,

In the properties of the objects, "General" tab, check "Always one selected value".

Regards,

Francisco

[#4]

Hi,

In the properties of the objects, "General" tab, check "Always one selected value".

Regards,

Francisco