Report Data Differs from Power Chart

Ignition
, ,
1

Hi
I have a report that is doing a tag history query with the following settings.

Query Settings
Query Settings829×193 26.1 KB

On the preview tab, it appears that it is returning the Min value as the Max value for the flowHr1 data key.

<row-2>
			<t_stamp>2023-08-02 00:00:00.000</t_stamp>
			<flowHr1>-0.03413502964468085</flowHr1>
			<levelHr1>24.608016967773438</levelHr1>
		</row-2>
		<row-3>
			<t_stamp>2023-08-02 00:00:00.000</t_stamp>
			<flowHr1>-0.03413502964468085</flowHr1>
			<levelHr1>35.771644592285156</levelHr1>
		</row-3>

When I throw the data points into a Power Chart to compare, they are returned correctly.

Power Chart
Power Chart1439×896 97.2 KB

Both keys are in the same data source. Why does the one match with the power chart and the other doesn't?

2

Hi @cole.young34,

Addressing the issue you're having could require substantial discovery and troubleshooting and therefore, to get a quick resolution to your issue, it would be best to reach out to our support department: https://support.inductiveautomation.com/

In case others in the community want to help, it would be useful to get clarification on what exactly you're expecting to see in the preview.

So, for , you expect to see -0.11 instead of -0.034...? If that is the case, it's interesting that the values are repeated on row 2 and 3.

Sometimes values get repeated and don't show up correctly when something went wrong importing the data key. How you brought the data key into the design section of your report would be a good place to begin investigating this issue - paying particular attention to the differences between the levelHr1 key and the flowHr1 key, including the key paths and where the keys are in the key browser relative to one another.

This page has some additional information about data keys: Data Keys - Ignition User Manual 8.1 - Ignition Documentation