Charts in Wappler

Wappler General
1

Hi All,

First off, I have been using Wappler for a few months now and love it.

I am hoping someone can help me when it comes to charts within Wappler. I can’t seem to find any general tutorial or how to guide on making charts. I did watch the video Lesson 16 - Introduction to using charts, but I’m still a bit lost in what I’m trying to do.

I trying to make a scatter or line graph based on Server Connect SQL query that includes a group by statement. The graph that I am trying to make seems quite simple but I can’t get it to work, I must be doing something stupid. I’m want to graph a value on the y axis against a timestamp on the x axis, where my group by groups my y axis value depending on a category related to that value.

Does anyone know the location of a tutorial that really dig’s into all of wapplers graphing capabilities?
Thanks in advance,

2

Just want to provide a bit more information. my data is like this:

TIMESTAMP SIGNAL DEVICE
xx/xx/xxxx 3 a
xx/xx/xxxx 4 b
xx/xx/xxxx 1 b
xx/xx/xxxx 3 a
xx/xx/xxxx 4 b
xx/xx/xxxx 1 a
xx/xx/xxxx 3 a

My Charts data source then has a group by Data format that groups by device. After this I want a line graph of:

x axis: timestamp
y axis: signal

with one line for each device.

3

This may help. It is the DMX Zone videos for the Charts Extension. The principal is pretty much the same as Wappler:

4

Thanks, I’ll take a look at those video’s.

5

I’m still at a loss as to using group by in my database query to create multiple data sets, i.e. have one line series for each of my devices.

EDIT:
Maybe my question is, is it possible to have a dynamic number of data sets in a graph (i.e multiple series of data) based on each device in my data.

Or can I do some sort of repeat in my chart so that it creates a dataset for each device?

TIMESTAMP SIGNAL DEVICE
xx/xx/xxxx 3 a
xx/xx/xxxx 4 b
xx/xx/xxxx 1 b
xx/xx/xxxx 3 a
xx/xx/xxxx 4 b
xx/xx/xxxx 1 a
xx/xx/xxxx 3 a