bar-line chart showing percent

[#1]

Hi there,

I am developing an application and one of the requirements is to have a chart that shows sales, budget and compliance (sales / budget) per month and per year.

Now I have the chart ready, however when I select a specific year compliance line is not displayed correctly, for further description send my chart if anyone can give me a hand.

Showing all years

Showing a specific year

[#2 · Accepted solution]

It is working for the expression you have entered, but you have the axis set to a static max of 1 and some of your values are over 200%. Ex:

[#3]

Thank you for your help,

I also want to know how I can automaticaly set the axis scale depending on the highest value of complianse (cumplimiento).

I appreciate your help

[#4]

I just find the way, I put on the axis scale the same expression of complianse using max()....

Thanks

[#5]

No prob. Glad you figured it out.