# Accessing specific value points of a history enabled tag dataset in the report function **URL:** \ **Category:** Ignition\ **Created:** [November 5, 2024, 11:23pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246 "2024-11-05T23:23:39Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![D\_Mitri\_Tompkins](https://avatars.discourse-cdn.com/v4/letter/d/a3d4f5/32.png) [@D\_Mitri\_Tompkins](https://forum.inductiveautomation.com/u/D_Mitri_Tompkins)\ **Post date:** [November 5, 2024, 11:23pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/1 "2024-11-05T23:23:39Z")
Have a tag with a dataset value, not sure how to be able to extract specific columns and rows for display in the report function's tag history query. When hoping to accomplish similar things with a tag history property binding I simply bind it to the tags value at the wanted column + row, such as `[default]tagname[14,3]` I am assuming I would interface the same way in the tag history query but currently that doesn't work, maybe it is an issue with it only recently having tag history enabled however Also, is there a way to bring information in this way in the format of [x,1] so it shows every row in column one? Or is this not a function of the reports history query? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [November 5, 2024, 11:36pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/2 "2024-11-05T23:36:11Z")
You tagged this `perspective` but you keep using the word 'report'. Can you post a screenshot of exactly what piece of UI you're interacting with, so we can align on terminology and make sure we're not leading you astray? ---
**Author:** ![D\_Mitri\_Tompkins](https://avatars.discourse-cdn.com/v4/letter/d/a3d4f5/32.png) [@D\_Mitri\_Tompkins](https://forum.inductiveautomation.com/u/D_Mitri_Tompkins)\ **Post date:** [November 5, 2024, 11:53pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/3 "2024-11-05T23:53:06Z")
Oh yeah shoot shouldn't have been perspective. I want to do this in the report function's data tag history query: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/8/08df33930fa7b5dba21962edc6ac79545bf777de.png) The tag I am working with is a dataset tag with history enabled: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/b/ab0b8e36aee5d0a36c5074a3f02f371c780027e0.png) The dataset looks like: ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/d/2d14e3ce26dd6a9e56a871fa4091cb1ad36c41ee.png) I want to be able to pull in specific row and column locations and historicize them using the reports history query so I can show their changes over time on a chart. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [November 6, 2024, 4:35pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/4 "2024-11-06T16:35:30Z")
That's going to be...difficult. Enabling history storage on a dataset does _nothing_ to help you disambiguate in the internal values, and is basically never going to be useful to you. You'll _have_ to use scripting to "post-process" the datasets you'll get out of your raw history query to turn them into regular flat data that the rest of the reporting module is able to handle. ---
**Author:** ![D\_Mitri\_Tompkins](https://avatars.discourse-cdn.com/v4/letter/d/a3d4f5/32.png) [@D\_Mitri\_Tompkins](https://forum.inductiveautomation.com/u/D_Mitri_Tompkins)\ **Post date:** [November 6, 2024, 4:48pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/5 "2024-11-06T16:48:25Z")
Any good places to start with that? The scripting in the reports is very confusing, or are you saying I need to script on a derived or reference tag? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [November 6, 2024, 4:50pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/6 "2024-11-06T16:50:21Z")
You would have to add a script data source. That data source would have to go through each row returned by your history data source (or you could directly run `system.tag.queryTagHistory` in your script). Then you'll have to go through every returned row and unpack the specific values you care about in each historized dataset, using those to build your own dataset(s), one column/dataset for each value you care about, then set those as new data keys to use them inside the actual report designer. ---
**Author:** ![D\_Mitri\_Tompkins](https://avatars.discourse-cdn.com/v4/letter/d/a3d4f5/32.png) [@D\_Mitri\_Tompkins](https://forum.inductiveautomation.com/u/D_Mitri_Tompkins)\ **Post date:** [November 6, 2024, 4:52pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/7 "2024-11-06T16:52:06Z")
Or would it be easier to instead bring the info in as a single tag per column (if that makes sense) For example the dataset is currently whatever number of headers (test type, test result, color grade) would it be easier to fill or write a tag for each header? So a tag for Test Type and then one for result and so on? ---
**Author:** ![D\_Mitri\_Tompkins](https://avatars.discourse-cdn.com/v4/letter/d/a3d4f5/32.png) [@D\_Mitri\_Tompkins](https://forum.inductiveautomation.com/u/D_Mitri_Tompkins)\ **Post date:** [November 6, 2024, 5:09pm UTC](https://forum.inductiveautomation.com/t/accessing-specific-value-points-of-a-history-enabled-tag-dataset-in-the-report-function/98246/8 "2024-11-06T17:09:10Z")
sounds miserable, I'll get to figuring that out thank you haha.