# Graph Generate + PDF & MAIL

**URL:** <https://discourse.nodered.org/t/graph-generate-pdf-mail/75739>\
**Category:** General\
**Created:** [25 February 2023 18:58 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739 "2023-02-25T18:58:50Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ankit.prasad](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@ankit.prasad](https://discourse.nodered.org/u/ankit.prasad)\
**Post date:** [25 February 2023 18:58 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739/1 "2023-02-25T18:58:50Z")

</div>

How to generate Graph from Influxdb .  
Use node-red and filter data based on API (unique ID) and generate PDF and automate it

During the Specified time -Shoot Email to user.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [25 February 2023 21:16 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739/2 "2023-02-25T21:16:12Z")

</div>

Grafana will do most (if not all) of that for you.

---

<div class="post-metadata">

**Author:** ![ankit.prasad](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@ankit.prasad](https://discourse.nodered.org/u/ankit.prasad)\
**Post date:** [28 February 2023 12:21 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739/3 "2023-02-28T12:21:25Z")

</div>

I need to generate Graph with some data like minimum temp  
maximum temperature  
device name  
device mac

for each unique mac address.  
later will send the report as mail

Need Guidance using node red

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/9/397c4312294e29c1f3119f4a37cdf5d99a3c713d.png)

[  
{  
"id": "3b59e4113fc119b1",  
"type": "tab",  
"label": "Flow 17",  
"disabled": false,  
"info": "",  
"env":   
},  
{  
"id": "ebef80b91b1e1991",  
"type": "inject",  
"z": "3b59e4113fc119b1",  
"name": "",  
"props": [  
{  
"p": "payload"  
},  
{  
"p": "topic",  
"vt": "str"  
}  
],  
"repeat": "",  
"crontab": "",  
"once": false,  
"onceDelay": 0.1,  
"topic": "",  
"payload": "[{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T14:00:00Z","\_value":47.2578125,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T16:00:00Z","\_value":56.796875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T18:00:00Z","\_value":62.4296875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T20:00:00Z","\_value":58.54296875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T22:00:00Z","\_value":65.8671875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T00:00:00Z","\_value":54.6640625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T02:00:00Z","\_value":76.515625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T04:00:00Z","\_value":57.546875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T06:00:00Z","\_value":45.38671875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T08:00:00Z","\_value":60.390625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T10:00:00Z","\_value":44.6015625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:00:00Z","\_value":39.21484375,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":0,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:15:13.804669687Z","\_value":45.3515625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T14:00:00Z","\_value":22.375,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T16:00:00Z","\_value":22.25,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T18:00:00Z","\_value":21.921875,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T20:00:00Z","\_value":22.078125,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T22:00:00Z","\_value":22.9609375,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T00:00:00Z","\_value":22.37109375,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T02:00:00Z","\_value":22.25,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T04:00:00Z","\_value":22.58203125,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T06:00:00Z","\_value":22.98828125,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T08:00:00Z","\_value":21.53515625,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T10:00:00Z","\_value":21.60546875,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:00:00Z","\_value":22.88671875,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":1,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:15:13.804669687Z","\_value":22.25,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_info":"KBPro\_285535","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T14:00:00Z","\_value":42.1875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T16:00:00Z","\_value":56.6953125,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T18:00:00Z","\_value":58.53515625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T20:00:00Z","\_value":55.41015625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T22:00:00Z","\_value":54.80859375,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T00:00:00Z","\_value":67.33203125,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T02:00:00Z","\_value":57.9140625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T04:00:00Z","\_value":62.53515625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T06:00:00Z","\_value":43.51953125,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T08:00:00Z","\_value":59.546875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T10:00:00Z","\_value":43.1875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:00:00Z","\_value":41.0390625,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":2,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:15:13.804669687Z","\_value":44.29296875,"\_field":"device\_humidity","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T14:00:00Z","\_value":22.2421875,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T16:00:00Z","\_value":21.9921875,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T18:00:00Z","\_value":21.8984375,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T20:00:00Z","\_value":22.81640625,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-27T22:00:00Z","\_value":22.66015625,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T00:00:00Z","\_value":22.04296875,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T02:00:00Z","\_value":22.265625,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T04:00:00Z","\_value":21.75390625,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T06:00:00Z","\_value":22.23046875,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T08:00:00Z","\_value":21.51953125,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T10:00:00Z","\_value":23.24609375,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:00:00Z","\_value":23.34765625,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"},{"result":"last","table":3,"\_start":"2023-02-27T12:15:13.804669687Z","\_stop":"2023-02-28T12:15:13.804669687Z","\_time":"2023-02-28T12:15:13.804669687Z","\_value":21.42578125,"\_field":"device\_temperature","\_measurement":"mem","clockin":"1","device\_mac":"BC5729008E48","gateway":"MOKO","gateway\_id":"0016","gateway\_insert":"1","gateway\_mac":"4091518a489a","host":"BC5729008E48","location":"BC5729008E48"}]",  
"payloadType": "json",  
"x": 110,  
"y": 80,  
"wires": [  
[  
"20f486b844849b60",  
"5eb5c536426af046"  
]  
]  
},  
{  
"id": "20f486b844849b60",  
"type": "debug",  
"z": "3b59e4113fc119b1",  
"name": "debug 302",  
"active": true,  
"tosidebar": true,  
"console": false,  
"tostatus": false,  
"complete": "false",  
"statusVal": "",  
"statusType": "auto",  
"x": 350,  
"y": 140,  
"wires":   
},  
{  
"id": "5eb5c536426af046",  
"type": "function",  
"z": "3b59e4113fc119b1",  
"name": "topic & 10",  
"func": "var arr = msg.payload[0] ;\n\nvar thetime, name, mac,data;\n\n\nthetime = (msg.payload[0].\_time); // Some manipulation of the time may be required\ndata = msg.payload[0].\_value;\nname = msg.payload[0].device\_info;\nmac = msg.payload[0].device\_mac;\n\nvar i = 10;\nif(typeof arr === undefined) {\n return ;\n} else {\n msg.payload = arr; \n msg.topic = 'Device Information';\n return msg;\n}",  
"outputs": 1,  
"noerr": 0,  
"initialize": "",  
"finalize": "",  
"libs": ,  
"x": 320,  
"y": 220,  
"wires": [  
[  
"26b65c6f186cfa4d"  
]  
]  
},  
{  
"id": "26b65c6f186cfa4d",  
"type": "template",  
"z": "3b59e4113fc119b1",  
"name": "html",  
"field": "payload",  
"fieldType": "msg",  
"format": "html",  
"syntax": "mustache",  
"template": "\n\n\<table border="0"\>\n \n \n Device MAC\n Alias Name\n Temperature\n \n {{#payload}}\n \<tr class=""\>\n {{device\_mac}} \n {{device\_info}}\n # {{\_value}}\n \n \n {{/payload}}\n\n",  
"output": "str",  
"x": 610,  
"y": 220,  
"wires": [  
[  
"02abd971817e5cb1",  
"da7c6e36ebff7dbb"  
]  
]  
},  
{  
"id": "da7c6e36ebff7dbb",  
"type": "file",  
"z": "3b59e4113fc119b1",  
"name": "",  
"filename": "test.txt",  
"filenameType": "str",  
"appendNewline": true,  
"createDir": true,  
"overwriteFile": "false",  
"encoding": "none",  
"x": 930,  
"y": 200,  
"wires": [  
  
]  
},  
{  
"id": "02abd971817e5cb1",  
"type": "debug",  
"z": "3b59e4113fc119b1",  
"name": "debug 303",  
"active": true,  
"tosidebar": true,  
"console": false,  
"tostatus": false,  
"complete": "false",  
"statusVal": "",  
"statusType": "auto",  
"x": 950,  
"y": 240,  
"wires":   
}  
]

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [28 February 2023 13:26 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739/4 "2023-02-28T13:26:27Z")

</div>

Did you look into doing it with Grafana.

---

<div class="post-metadata">

**Author:** ![ankit.prasad](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@ankit.prasad](https://discourse.nodered.org/u/ankit.prasad)\
**Post date:** [1 March 2023 14:05 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739/5 "2023-03-01T14:05:11Z")

</div>

Can you help on this !!!

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 March 2023 14:33 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739/6 "2023-03-01T14:33:53Z")

</div>

Help with what? Generating PDF files from Grafana?

I have not done it, but I googled for  
grafana generate pdf  
and there were numerous hits that suggested that this could be done. If I were doing it I would start by looking at those.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [30 April 2023 14:34 UTC](https://discourse.nodered.org/t/graph-generate-pdf-mail/75739/7 "2023-04-30T14:34:44Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.