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
You should use a Column Series chart — each row key becomes a point on the X axis and each column becomes a series
@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…
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
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 ?
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.
@praveen OK Label was set automatically on PHOTO by app, i set it to my [Number] and it is ok.
You can have a text label and also a photo label. So no harm having both marked.
@praveen OK THX
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |