Time Series Graph Formatter Not Working on Summ Aggregation

Help
1

Hello,

I have a time series graph element in a Losant dashboard. I am intending to use Summ aggregaton, for the first time. I have a time series attribute with 'each’s and I want to add them all up for each Resolution (24hr) bucket.

This seems to work, but puts the data into Scientific Notation. No problem, ive used the handelbar formatter before to remove that, but in this case it doesnt seem to do anything.

image
image2412×768 69.7 KB

If I change back to MEAN aggregation, the formatter appears to function as expected.

image
image2350×1203 193 KB

And then back to SUM

image
image2290×1195 188 KB

I feel like the formatter is applying to the data before the aggregation happens perhaps? What am I doing wrong to prevent the formatter against the expression from working properly here?

My goal would be to not show it in scientific notation.

2

That field you are putting the {{format}} helper in is not for formatting the tooltip; it’s an expression for transforming the data point that is being put on the graph.

For example, if your device was reporting temperature in Celsius and you wanted to display it in Fahrenheit, you would provide an expression of (9/5 * {{value}}) + 32.

When the expression fails to render to a number, it falls back to the original value, which I think is what is happening in your case when you switch between MEAN and SUM aggregations.

You should instead be able to accomplish what you are after using the “Y Axis Format” input within the segment config.

1 Like