How to create a histogram in AWS QuickSight without using aggregate functions?

I apologize, but there seems to be a misunderstanding in your question. Histograms in Amazon QuickSight are specifically designed to show the distribution of continuous numerical values in a dataset, and they inherently use aggregation to create bins and count the number of data points in each bin.

In QuickSight, histograms are created using one measure, and they automatically divide the data into bins (initially 10 bins, but this can be customized). The Y-axis displays the count of values in each bin, which is a form of aggregation.

Histograms in QuickSight do not support plotting individual data points over time without aggregation. If you want to plot your IoT data values directly over time without aggregation, you might be looking for a different type of chart, such as a line chart or scatter plot.

For a line chart or scatter plot, you could use your timestamp as the X-axis and the corresponding values on the Y-axis. This would allow you to visualize your data points over time without aggregation.

If you specifically need a histogram to show the distribution of your IoT data values, you would need to use the built-in aggregation. The histogram will show how many data points fall into each range of values, which can be useful for understanding the overall distribution of your data.

Remember, histograms are designed to show the shape of the distribution of a dataset, not to plot individual data points over time. If you need to see individual data points, consider using a different chart type that's more suitable for time-series data.
Sources
Using histograms - Amazon QuickSight
HistogramVisual - Amazon QuickSight
HistogramConfiguration - Amazon QuickSight