Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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é
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)