Hi, try to configure Chart but don't find how...

(Arnaud B.) #1

Hi, try to configure Chart but don’t find how to choose X / Y value to have something so. What kind of chart need i and how to configure it ? THX

(Praveen Seshadri (AppSheet)) #2

You should use a Column Series chart — each row key becomes a point on the X axis and each column becomes a series

(Arnaud B.) #3

@praveen OK but the result isn’t like as i would. The Y show my duration, it’s ok, but the X line isn’t on the column i would.

With Row Series, it’s look better but column aren’t side by side and the X line as the same problem…

(Arnaud B.) #4

@Arnaud_B

(Praveen Seshadri (AppSheet)) #5

Not sure how you set that up, but let’s assume your table has three columns (Number {key}, Duration1, Duration 2). If you set up a Column Series chart with Duration1 and Duration2, you should see a chart with 2 bars for each X-axis entry.

My guess is that you haven’t chosen the Key column of the table correctly. The Key is what you’ll see on the X-axis

(Arnaud B.) #6

Problem, i have around 30 columns in my sheet. Key column is one UniqueID. I’ve a slice for filtering data and configuring my chart. App choose a text column for the X, i don’t know why. Need i to remove some columns in the slice configuration ?

(Praveen Seshadri (AppSheet)) #7

If it is a column-series chart, then the X-axis has rows (with the Label column from the column structure). Make sure the slice has the row key and the row label column.

(Arnaud B.) #8

@praveen OK Label was set automatically on PHOTO by app, i set it to my [Number] and it is ok.

(Praveen Seshadri (AppSheet)) #9

You can have a text label and also a photo label. So no harm having both marked.

(Arnaud B.) #10

@praveen OK THX