Bar chart Year per dimension

[jose_vargas]

Hi Community.

I have a boar with the next information.

Grapich Bar Chart with 2 dimension (Month and Year), I have 2 Expression,  the first expression is "Daily HV" it have to be a Bar and in my example its OK. the second expression is "Daily % Mix" and I need to show in line for each year, in my example I selected 2 years (2017, 2018) and I need to sho 2 line, one line for 2017 and another line for 2018. Its that possible???

Now show one line

Something like this

Best regards.

José

[jonathandienst]

You may get better results with a combo chart with 4 expressions (rather than two expressions and year in the dimension) and only Month as the dimension. Select the year in the expressions with a set filter, a pattern like this:

Sum({<Year = {2017}>} Value)
Sum({<Year = {2018}>} Value)

Dynamically:

Sum({<Year = {$(=Max(Year)-1)}>} Value)
Sum({<Year = {$(=Max(Year))}>} Value)