Problem in chart

Hi Anes,
can you please post also the tabular data that you obtain when testing the query? I need to understand what’s the expected behaviour. I mean, are there values in the “goal” column of the result?
thanks
Claudio

Dear Claudio,
There is value in the goal column and it’s value is fixed (89). My expected behaviour is when click on the points the value in tooltip must display properly , all others are working well now. I attach the
tabular data when query execute below:

https://postimg.org/image/ejypnw7r5/

Please advise me
Thanks,
Anes

Hi Anes,
The behaviour is weird, I cannot reproduce it. Can you maybe try to set the dates in ascending order? I think that maybe having shuffled dates can have an impact on rendering.
claudio

Dear Claudio,
I checked the query with ORDER BY add_date DESC but still the same problem occurs . I attach the settings and my db table sql files regarding this issue .
https://www.mediafire.com/view/1qbqvjfv31whlam/wp_weight.sql
https://www.mediafire.com/view/10gwvq05c7ag3qj/wp_users_test.sql

Settings preview
https://postimg.org/image/wytn2hnb5/
You can find my working query in preview itself .

Please advise a solution for this.

Thanks,
Anes

Hello Anes,
actually I found out that this happens because one serie has the same value as the other. It must be a bug with nvd3.js the chart library we use in the plugin. We’re currently looking into it.
Anyway with other configurations of point the issue seems to be not present.
I’ll let you know as soon as I find a solution.
regards
Claudio