Xy chart help, named query, settings changing

Sure, let’s use the default XY Chart as example.
I want to rename the xAxes name so I note the current name (time)

Then I change to my new name (time2), which breaks the rendering.

So what I would do is search for the orignal xAxes name time.

Adjust any properties that use the xAxis and it renders correctly.

Hope that helps. FYI, my last post was based on your first post (before editing the props.series screenshot). So it seems like you figured it out but as for the copy and paste to another view… not sure what’s changing but you can compare the raw JSON of the 2 views and see what changed.

2 Likes

Thanks

How do I point the pen name at the label shown on the dropdown I have above it?

I only see value there. I don’t see the label available.

Then also, when I pick a different machine from my dropdown, my graph goes to only showing two data points.
The first day and the last day.
If I refresh the page, then it will update with the days between showing data.

So second question, is how do I get the chart to update the data points as well.

I will snip some images.

malfunctioning graph

functioning graph after a refresh

For now, I am using a time series chart with a different query, but the dates don’t show right at the bottom because they are not tied to my days, but just time as it goes

I wanted to thank you, as your information helped me again.

This time I am setting the series rendering to column for bar graphing

1 Like

I am a bit stuck on a few things.

Spacing the bars apart

I found width of the bars in the columns for series 0
https://docs.inductiveautomation.com/display/DOC81/Perspective+-+XY+Chart

75 seems to be default, and the space increases when I set the width lower.

err update
I guess with null, it scales to the width of the graph
so I just set the width and make the graph wider

having alignment issues
8.1.0

My query returns information grouped by day.

group by  FORMAT(t_stamp, 'MM/dd/yy'),Line

I did fiddle with the width and spacing though.
chart is set for 1600px, with columns set width:50
showing 30 days
Changing the dimension 1600x doesn’t seem to impact the alignment, scales with incorrect position/misaligned as I make the chart smaller or larger.

This is a known issue. You can play around with CSS and make it better, if it's worth the effort for you.

See here:

There is a solution for either the power chart or the XY chart.

1 Like

Thanks @lrose

image

I don’t understand how it happened.
Seems like an X and Y got mixed up?
but when I look, I see the correct X and Y values

X:Day
Y: mydependentvariable

tooltip is set to read the {valueY}, but that part is blank
my values do not increase that way

image
what?
the scale is reorganizing to make the values appear to increase with time?

I hope I did something wrong.
I am on 8.1.0
I hope I can get it to work in 8.1.0
I might contact support to help to get me unstuck

Is this caused by the css or something else? Cuz it might be that some numbers need to be changed if you are using multiple series/axes ect

I don’t know what is causing it.
I am expecting a call back from support.

It is really odd to me.
The scale is messed up in both renders
The second set of Y is showing up 90° the wrong way in bar render
I just hope that it is not because I am using 8.1.0 because I don’t know when my company will update.

My current workaround is to have a graph for each series.

I don’t think time series can show bar graphs or can they?

no they cant

what about putting the number value at the top of a bar when making a bar graph

I saw one person was making a line render to do this, but I thought maybe it was just a special case

I am set for category
I have a column of the last 60 days as yyyy-MMM-dd

What is the way to set the specific cell in my table to the startCategory ?
I tried to find it on Perspective - XY Chart - Ignition User Manual 8.1 - Ignition Documentation
I don’t see it though
I tried example [0,1], but this did not work
For the endCategory I would need to pick the last one in a changing dataset, or I think maybe I can say like 60 days after the first one somehow


and now I have the sideways graph error again

my x and y are not mixed up, but they are appearing that way.

then when I used same y axis for two series, and try to stack them, instead of stacking, they are just wider, and for the entire length


found the way to get shorter dates, it looks at the first column for dates, so I set the format to MM-dd in my query for the first select of outer query

but now it only shows like 3 dates and still is sideways in the view


Got tech support, they wrote a brief script to make a pydataset of the required data, and without the rest. This made most of the chart shape up better.

set for category on the x axis
40 minDistance grid spacing
12 font, 0.5 positioning
looks good, but newer versions of Ignition have the rotate feature that would be nice for my x axis

I need some XYChart help again, please.
I want to keep this stuff in the same thread so I can find it at one time, forgive me for any inconvenience.

Now that I am on 8.1.19, I have implemented turning the text vertical for my reason codes.
The reasons are different lengths.

How do I get the charts to line up vertically if the text is different lengths rotated 90degrees?

I tried adding wrap, but the text did not wrap.
I don't see how to set/limit the space for the text to make it wrap, and I did add wrap that is not available by default.
image

Vertical alignment of these XY charts is still an issue for me.
I added wrap and set it to true in the x axis appearance labels.
Doesn't wrap.
Ignition version 8.1.19

Also, I added some lines to my chart, but the tool tips are not showing up when I hover the lines.

image

I checked these posts, but no luck.

Perspective XYChart, Tooltip on Line Series]
[Bug-11636] - XY Chart Tooltip Background Color
Perspective XY Chart - Tooltip w/ Multiple Series' Data

I checked these documents, but no luck.
Perspective Component Properties - Ignition User Manual 8.1 - Ignition Documentation]
Perspective - XY Chart - Ignition User Manual 8.1 - Ignition Documentation
Formatting Strings – amCharts 4 Documentation

My tooltip doesn't have have a style property.
Attempting to add the style did not work with or without quotes, forward or backward slash.
image

Adding variations of /n and {extraColumnName} didn't give me any change in the results of my tooltips at all, which this seemed odd to me.

I need an XY Chart hero.

I need either a solution that shows all my values in a single tooltip:
image

Or I need a solution that shows the tooltip when the object is a line render:
image


@Transistor thanks
I found your example.
Perspective XY Chart xAxes tooltip text {dateX}]
I don't have any idea why it doesn't work on my line renders.
It did work on my column renders.

image

Are adapters something I can perform on the XY chart?
I think I want one to perform on the valueY.low because right now it returns 0, and I want the value that is next after 0.
Consolidating values from multiple axes into a single tooltip – amCharts 4 Documentation]

You need to have the bullets enabled as the tooltips are connected to those, not the line itself. You can set the bullet opacity as low as you want. I usually leave a ghost of them there so the user knows where to find the tooltip.

2 Likes

Thanks so much.
Bullet opacity, I can't believe I didn't test that. Worked great.
image

Questions:
Do you know about if we can use adapters?
Have you had good results with bindings on tooltips?
Is there a way to get the tooltip to show me the valueY.low that is not 0?

  1. I don't know what an adaptor is.
  2. I've never tried bindings.
  3. I don't know.

Sorry.

1 Like

Adapters – amCharts 4 Documentation]