Graph not showing

[sachin_jangir]

i want a graph whiich look like this
so in above image there is two line which one is blue and other is pink but in other screen it is showing like
and i have done the mapping correct

please help me how to fix this

[ThinhDinh]

Are you sure you have done the mapping correctly? Why is your supposed to be blue line showing in pink?

And why are your columns not given a name?

[sachin_jangir]

after fiving column name it will work??

[sachin_jangir]

*giving

[ThinhDinh]

No it won’t, I’m just asking why don’t you give your column names to manage it better? There’s a chance you may miss something if you don’t give them names, especially with a structure requiring so much data like this.

[sachin_jangir]

i checked thrice it is mapped correctly i am facing this issue from 2 sep can you please help

[ThinhDinh]

I would plug that template into Quickchart’s sandbox, replace the values manually there, then check the resulting graph to make sure it is completely true.

Your way of doing it here is not what I usually do. I usually have just the configurations part in the template, the URL construction part should be done in a construct URL column.

Quickchart.io: the Cloudinary of Charts —on the fly charts!

So here is the one I did using the Construct URL column… Started off with a URL that looked like: https://quickchart.io/chart?bkg=white&c={.........} There are two query parameters in that URL: bkg=white c={ JSON structure } So I took the whole JSON structure, and put that in a template column: [Screen Shot 2021-02-02 at 10.40.54 PM] Then defined the Construct URL column as follows: [Screen Shot 2021-02-02 at 10.41.52 PM] The first query parameter was simple, so I “hard-coded” that, …

[Darren_Murphy]

oh, my…

Are you really using 100+ unnamed columns as your data source?
That’s going to be an absolute nightmare to maintain. What will happen when you need to add more data points? More columns?

The one big thing that screams at me when I look at that is that your data should be in rows - not in columns. Then instead of 100 or more replacement values, you would just have one: which would be a joined list of all rows.

Just to give you an example, I do lots of charts like this. Here is what my template column typically looks like:

In the above template, I have just 3 replacement values:

• {labels}: a joined list of the chart labels (x-axis)
• {supply-data}: a joined list of values for my first set of data points
• {box-data}: a joined list of values for my second set of data points

The resultant chart looks like this:

The important point that I’m trying to make here is that it doesn’t matter if I have 10 data points in the chart, or 1000 data points - there will always be just 3 replacement values in the template.

[Jeff_Hager]

One thing that I’m noticing is a lot of hanging commas. There’s a lot is places where the list of attributes end, but there is another comma, like it’s expecting another attribute. Hard to say if that’s the problem though. The only way I would be able to tell is if you copied and pasted the full text of the resulting template here in the forum. It’s hard to determine for sure with just a screenshot.