Yes, I have used these sites to create the expression.

The expression is correct but there is no update at the correct time.

I'm guessing that it should if some other configuration, such as context event type that may be wrong.

Hello, I created a script and wanted it to update every day and every hour in minutes and seconds 59.
I made the expression cron (59 59 * * *? *), But it is not updating at that exact time I requested.

Here is the image of the settings, but do you have a suggestion of what it could be?

It would be to read device historical values. It does not present "presentValue" for some data types.

@leoboeng Any suggestion ?

ok thank you, I tried with all but 0.0.0.0.

I started to mess with bacnet now and I'm kind of lost, but thank you !!

Would not it be possible to pull the value of a TrendLog type variable?

Hello, I'm starting to mess with BacNet IP devices and I'm facing some problems.

In the part of Backnet Local Devices I put the IP of the Linux server that is running the Mango (192.168.0.23)

So I went to configure Data Soucer but it does not connect and does not find the points

I tried both with the ip of the server mango (192.168.0.23) and the Ip of the BacNet-enabled device (182.168.0.241) and neither of them connected.

Following is information from my Bacnet device:

@craigweb said in Problem with Pie Chart:

Trying to get the unit on the value seems to be giving more problems than it is worth. Is it not enough to put the unit in the text?

Hello,

Yes, but the problem I was facing is that even the decimal place I was able to put rendered, ie the value of the point came with 4 decimal places and just wanted to show 2, but your formula that passed me has already served and worked.

It would be nice to have the unit follow up but I'll text it.

Ah, thanks for the help.

I tried the following ways and even then continued showing a pie chart in "white"

<ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>    
  
<ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 30px;" values="[{ value: parseFloat( P_Ativa_A.renderedValue.split(' ')[0]), text: 'Fase B', color: 'black' },]" options="{depth3D:15,angle:30}"></ma-pie-chart>

<ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>    
  
<ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 30px;" values="[{ value: P_Ativa_A.renderedValue.split(' ')[0], text: 'Fase A (A)', color: 'black' },]" options="{depth3D:15,angle:30}"></ma-pie-chart>

All two codes showed the graphic in "white":

My points are configured as follows:

It pulls the data as follows:

@mattfox said in Problem with Pie Chart:

if so, this is how I'd do it and just add the unit to the text

But doing so I would have to take the unit out of the point configuration, correct?

@mattfox said in Problem with Pie Chart:

So first off, the units come in looking like 5,0490 5.9382 4,0983 the comma for each measurement's decimal place and a space to separate each house.
Secondly, you only want the units to be 3 significant figures long, without rounding.
Thirdly, you want to be able to use the Unit on the pie chart.
I'm I hitting the nail on the head?

Yes that's right.

The formatting with 3 significant units but I already got it.

In the pie chart without the Units of Measurements it is possible to make a "point.renderedValue", but when units are added the pie chart does not work.

So I used the "Slice", as I was shown, it worked about 2-3 days and today started to present that problem.

@mattfox said in Problem with Pie Chart:

So you're telling me the data comes in as comma separated values???
Could you please output the individual points data line by line so I can see how it sits within your markup?

I have no more in front of the server for this, and even apologize for my English, I'm from Brazil and here the separation is made by commas (,), in the case of you points (.).

The values ​​come in the following format, for example:

Electric_current_Phase_A:

5.0490
5.9382
4.0983

In my formatting by Mango, it shows as follows:

Electric_current_Phase_A:

5.04 A
5.93 A
4.09 A

That is why I say that the need for units is important to me, in the case of exemple the Amper (A), and this is what has been complicating my Pie Chart.

@mattfox said in Problem with Pie Chart:

Then why not just stick to using '.value' rather than using '.renderedValue' and making it more complicated than necessary?

For it is about electrical measurements and the better visually go accompanied by their units. In addition, the meter pulls data with 4 houses after the comma, for example 5.0892, and I want to work with only 2 houses.

In the matter of decimals it is quieter because the "point.renderedValue" only works with this type. It stops working when I add the Unit of measurement and this for me is very important because there are other graphs, and lists that work with it, so I can not take it. And it is not at all feasible for me to create 2 points just to make that point distinction with unit of measure and point without unity.

I have already updated the page, restart the server, check the internet and everything ok. I did a chart pie only with the values ​​of the points "point.value" and showed everything correctly. I did not move in any configuration of the point, it was working correctly and the point is still being updated the values, just does not show the graph anymore. So much so that the "Total" is the sum of all the points that compose the char pie.

I did not make any major changes to the code that was passed to me just added some items that are not part of the chart pie. On the chart pie I just added the caption.

@phildunlap Yes it is a numerical point rendered with unity. They are power measurements, no conversions are made, the values are pulled directly from a ModBus TCP / IP meter.

The code was working perfectly but it stopped working.

<div class="ma-designer-root" id="69cb3d48-9218-481c-98fd-32a687ea174e" style="width: 1366px; height: 768px; position: relative;">
    <ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_807622" point="P_Ativa_B"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_515819" point="P_Ativa_C"></ma-get-point-value>
    <ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 40px;" values="[ { value: P_Ativa_A.renderedValue.slice(0, P_Ativa_A.renderedValue.indexOf(' ')), text: 'Fase A', color: 'red' }, { value: P_Ativa_B.renderedValue.slice(0, P_Ativa_B.renderedValue.indexOf(' ')), text: 'Fase B', color: 'black' }, { value: P_Ativa_C.renderedValue.slice(0, P_Ativa_B.renderedValue.indexOf(' ')), text: 'Fase C', color: 'white' } ]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
    <div id="6da01089-3a57-4adc-820d-c7b16e317f4d" style="position: absolute; left: 248px; top: 14px;">Demanda (kW)</div>
    <ma-point-value id="6da01089-3a57-4adc-820d-c7b16e31734e" style="position: absolute; width: 95.9688px; height: 18px; left: 457px; top: 319px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_892466"></ma-point-value>
    <div id="9a443ad1-7ffa-4ea9-b6cf-81afbd5ba0a5" style="position: absolute; left: 409px; top: 317px; font-size: 14px;">Total:</div>
    
    <ma-get-point-value point-xid="DP_147675" point="P_Reativa_A"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_495992" point="P_Reativa_B"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_170532" point="P_Reativa_C"></ma-get-point-value>
    <ma-pie-chart id="51518ce5-4bbd-436c-b152-33b9cab8b661" style="height: 303px; width: 612px; position: absolute; left: 612px; top: 40px;" values="[ { value: P_Reativa_A.renderedValue.slice(0, P_Reativa_A.renderedValue.indexOf(' ')), text: 'Fase A', color: 'red' }, { value: P_Reativa_B.renderedValue.slice(0, P_Reativa_B.renderedValue.indexOf(' ')), text: 'Fase B', color: 'black' }, { value: P_Reativa_C.renderedValue.slice(0, P_Reativa_C.renderedValue.indexOf(' ')), text: 'Fase C', color: 'white' } ]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
    <div id="5260430c-4141-4b8c-841c-a295939587e0" style="position: absolute; left: 839px; top: 15px;">Demanda Indutiva (kVAr)</div>
    <div id="8ec6afb5-9c47-4b3f-b2f4-15c313f36895" style="position: absolute; left: 1038px; top: 318px; font-size: 14px;">Total:</div>
    <ma-point-value id="a040eff7-b295-432b-8d1c-ce5e6df3aba3" style="position: absolute; width: 95.9688px; height: 18px; left: 1094px; top: 321px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_138259"></ma-point-value>
    
    <ma-get-point-value point-xid="DP_954001" point="A_AtivoDiario_FP"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_940363" point="A_AtivoDiario_P"></ma-get-point-value>
    <ma-pie-chart id="878e8fce-42a5-4291-ab8c-db54f97af9e1" style="height: 420px; width: 641px; position: absolute; left: 0px; top: 342px;" values="[ { value: A_AtivoDiario_FP.renderedValue.slice(0, A_AtivoDiario_FP.renderedValue.indexOf(' ')), text: 'Consumo Fora de Ponta', color: 'red' }, { value: A_AtivoDiario_P.renderedValue.slice(0, A_AtivoDiario_P.renderedValue.indexOf(' ')), text: 'Consumo na Ponta', color: 'black' }]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
    <div id="53397a10-40d3-497a-a11c-5f9f1c7a3fa9" style="position: absolute; left: 233px; top: 411px;">Consumo Ativo Diário (kWh)</div>
    <div id="e42746f5-2cc7-43fe-b715-515a85904545" style="position: absolute; left: 454px; top: 734px; font-size: 14px;">Total:</div>
    <ma-point-value id="997cb925-2c57-4d6f-9747-6bd18b41c2d0" style="position: absolute; width: 95.9688px; height: 18px; left: 517px; top: 735px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_929069"></ma-point-value>
    
    <ma-get-point-value point-xid="DP_280526" point="A_AtivoMensal_FP"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_738729" point="A_AtivoMensal_P"></ma-get-point-value>
    <ma-pie-chart id="1a248030-0ea5-4a94-a659-f60b1bdce677" style="height: 420px; width: 641px; position: absolute; left: 641px; top: 342px;" values="[ { value: A_AtivoMensal_FP.renderedValue.slice(0, A_AtivoMensal_FP.renderedValue.indexOf(' ')), text: 'Consumo Fora de Ponta', color: 'red' }, { value: A_AtivoMensal_P.renderedValue.slice(0, A_AtivoMensal_P.renderedValue.indexOf(' ')), text: 'Consumo na Ponta', color: 'black' }]" options="{depth3D:15,angle:30,legend:{'position':rigth,marginRight:100,autoMargins:false}}"></ma-pie-chart>
    <div id="fd952897-7ff7-49fd-86da-c31e75633f7f" style="position: absolute; left: 875px; top: 411px;">Consumo Ativo Mensal (kWh)</div>
    <div id="5cb80112-7e0a-47c6-a5d7-e6582422d2ab" style="position: absolute; left: 1098px; top: 734px; font-size: 14px; width: 30.9531px; height: 19px;">Total:</div>
    <ma-point-value id="54931f3a-3721-45c9-a618-c075ef353298" style="position: absolute; width: 95.9688px; height: 18px; left: 1157px; top: 736px; text-align: center; line-height: normal; font-size: 12px;" point-xid="DP_185150"></ma-point-value>
</div>

Do you have any idea what the problem might be?

Thank you!!
And how do I show the rendered value? I tried the following but it did not work:

    <ma-get-point-value point-xid="DP_530359" point="P_Ativa_A"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_807622" point="P_Ativa_B"></ma-get-point-value>
    <ma-get-point-value point-xid="DP_515819" point="P_Ativa_C"></ma-get-point-value>
    <ma-pie-chart id="63759ca9-e465-45e3-80b8-89cda82627fe" style="height: 303px; width: 612px; position: absolute; left: 0px; top: 30px;" values="[ { value: P_Ativa_A.renderedValue, text: 'Fase A', color: 'red' }, { value: P_Ativa_B.renderedValue, text: 'Fase B', color: 'black' }, { value: P_Ativa_C.renderedValue, text: 'Fase C', color: 'white' } ]" options="{depth3D:15,angle:30}"></ma-pie-chart>
</div>

@phildunlap said in Excel Report:

the top section of /system_settings.shtm

I just checked the top section of /system_settings.shtm and I actually saw that you are using H2.

I think it was something of the update, because I made an update and since then it did not work anymore, but before that it was like MYSQL.

I will pass the database to MYSQL and check if the error will continue.

Hi, I switched to MySQL as recommended, but started to make the same mistake. Follow the error photo

Hi, I'm trying to make a pie chart based on a point but I can not do it. I did the following but it did not work:

<ma-get-point-value point-xid="DP_698831" point="myPoint"></ma-get-point-value>
<ma-pie-chart style="height: 300px; width: 600px" values="[ { value: myPoint, text: 'hot', color: '#ff9300' }, { value: 5, text: 'cold', color: '#942192' } ]"
options="{depth3D:15,angle:30}"></ma-pie-chart>

In the API it says that the value has to be number, someone knows to tell me how do I use the Point value instead of a number?

Ah ok thanks, I typed the wrong password. I already made another user use root only for testing.

But do you know if I can copy the data from the old database to the new sql? I tried the backups but it did not work if you missed a large part of the setup.