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
Thread Starter
anespa
(@anespa)
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:
http://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
Thread Starter
anespa
(@anespa)
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 .
http://www.mediafire.com/view/1qbqvjfv31whlam/wp_weight.sql
http://www.mediafire.com/view/10gwvq05c7ag3qj/wp_users_test.sql
Settings preview
http://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
