This is probably a simple question, but canโt figure out how to do it!
I have a dataset with three variables, [category], [date], [measure]
I would like to create a line chart where the x-axis is [date], the y-axis is [measure] and the graph only presents 1 level of category (either by drop down, or via table/dashboard)
Can anyone help?
Attach you chart to a slice.
Thanks, itโs less the slicing more using the date on a time series that I am having issues with. I canโt seem to get the X axis to show the date field:
The Figure below should show [date] on the axis instead it shows the [category]
On my chart view I donโt seem to have the option to select date at any point (e.g. chart columns does not allow selection of dates).
Iโm probably missing something obvious as this seems like a pretty simple graphicโฆ
Iโve also got the same problem. Iโve worked with Appsheet charts a lot and have never realised that you actually canโt have a chart with time (or date, or datetime) as the x-axis!
Surely this is an omission!
If I want to chart [Blood Pressure] against [DateTime] where [Blood Pressure] is Decimal and [DateTime] is a Datetime then the best I can do is to have [DateTime] as the label.
But this is not actually what @Dave_Inman or myself were really after. It displays the points in a sequence, but if you miss a week then this gap will not be reflected in the chart because itโs just a sequence of dots with lables.
The behaviour that @Dave_Inman or myself were really after is a real plot of how a parameter varies with time.
Try it. Itโs impossible.
@TDhers This is pretty much exactly what we were discussing RE: Resource histograms. Often for date/datetimeโฆ Itโs important to be able to define that continuity somehowโฆ
These charts for example display process parameters.
Plotting things in โtimeโ has GOT to be the most popular use of charts surely โฆ
Itโs only months later that I realise that itโs not actually a plot of a value against time โฆ
itโs only data ordered by a label.
And hence any gaps will not be rendered correctly on the chart because every point only has a y-value and a label.
I also note that if Iโm happy to have no actual x-axis (i.e. use dates as labels) then my y-axis DOES zoom to the data range being displayed โฆ
But if I want to plot an X-Y plot (which I can ONLY achieve by constructing a virtual numeric column expressing each date as a decimal number of days from today) then my y0axis DOESNโT zoom to the data range being displayed โฆ
The expected behaviour would be to have it zoom the same.
Yes, totally agreed and understood.
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |