Evenly Spaced Chart Axis

Dashboard
,
1

I'm just curious if there's a way to have the X-axis of my chart display the date and time each data point was recorded, while keeping the spacing between points even—so there aren’t large gaps when data is collected irregularly (e.g., every hour or every few days). I've included the function block that feeds the chart, the chart itself, and the chart setup. Any information or help on this would be appreciated!

flow.set('selectedPart', msg.payload)

const selectedPart = flow.get('selectedPart') || '';
const productionQuery = flow.get('productionQuery') || [];

let result = [];

if (selectedPart === "") {
    result = productionQuery;
} else {
    productionQuery.forEach(item => {
        if (item.PartNumber === selectedPart) {
            result.push({
                Weight: item.Weight, 
                Date: item.Date_and_Time
                }); 
        }
    });
}

msg.topic = selectedPart
msg.payload = result;
msg.selectedValue = selectedPart
return msg;

image
image650×889 20.6 KB

image
image613×531 12.5 KB

2

Currently supplementing by using the bar chart and sending the dates in as categories. Not ideal but it works.

image
image618×625 12 KB

3

You can set the axis type to categorical with a line chart, which if I understand correctly is what you want. Make sure the date entries are strings.

4

I thought that was an option, but I am only seeing time scale and linear as an option

image
image844×779 24.9 KB

5

Update to the latest version of the dashboard (1.28.0). This was introduced recently.

6

Thanks didn't notice there was an update available.