Charts - Daily Time Series

[Dave_Inman]

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?

[Steve]

Attach you chart to a slice.

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

[Dave_Inman]

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…

[Andrew_Smith1]

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.

[Grant_Stead]

Andrew_Smith1:

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.

@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…

[Andrew_Smith1]

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 …

[Andrew_Smith1]

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.

[Andrew_Smith1]

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.

[TDhers]

@jared @Arthur_Rallu ^

[TDhers]

Yes, totally agreed and understood.