# Move the decimal place of Killowatthours?

**URL:** <https://community.grafana.com/t/move-the-decimal-place-of-killowatthours/80399>\
**Category:** InfluxDB\
**Tags:** influxdb, query-help, override\
**Created:** [January 25, 2023, 12:26pm UTC](https://community.grafana.com/t/move-the-decimal-place-of-killowatthours/80399 "2023-01-25T12:26:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![starfoxfs](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/starfoxfs/32/29112_2.png) [@starfoxfs](https://community.grafana.com/u/starfoxfs)\
**Post date:** [January 25, 2023, 12:26pm UTC](https://community.grafana.com/t/move-the-decimal-place-of-killowatthours/80399/1 "2023-01-25T12:26:49Z")

</div>

Hi,

a simple Question, i have Data from my Powermeter in the right Format.

e.g. 14600.8 KwH

If i add these to Grafana and use the Unit KwH Killowatthour it changes the decimal Place and the Unit to MwH Megawatthours  
Unit KwH:  
Is shown as 14,6 MwH

If i use Watthours the decimal place is on the wrong position.  
Unit WH:  
14.600 KwH

Can i manually override these decimal Place ?

---

<div class="post-metadata">

**Author:** ![ldrascic](https://avatars.discourse-cdn.com/v4/letter/l/aca169/32.png) [@ldrascic](https://community.grafana.com/u/ldrascic)\
**Post date:** [January 25, 2023, 8:40pm UTC](https://community.grafana.com/t/move-the-decimal-place-of-killowatthours/80399/2 "2023-01-25T20:40:25Z")

</div>

Hi @starfoxfs,  
If I assumed correctly, you want to show values with MWh unit but with more decimals?

> Real value from powermeter: 14600.8  
> Desired value: 14.6008 Mwh ?

Here is a picture where I have 3 identical queries but they differ in unit and number of decimals:

> A query shows real numbers (like the they are stored in database  
> B query shows numbers in MWh because with unit we told Grafana “Hey, my numbers are always in kWh and change unit accordingly”.  
> C query is same as B but we allowed 3 decimal numbers

 ![Grafana stat panel metric unit and decimals](https://us1.discourse-cdn.com/grafana/original/3X/a/a/aab68fde4895e25c1bbec3bbad94b0ead49f9ee8.png)

Best regards,  
ldrascic

---

<div class="post-metadata">

**Author:** ![starfoxfs](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/starfoxfs/32/29112_2.png) [@starfoxfs](https://community.grafana.com/u/starfoxfs)\
**Post date:** [January 26, 2023, 1:59pm UTC](https://community.grafana.com/t/move-the-decimal-place-of-killowatthours/80399/3 "2023-01-26T13:59:51Z")

</div>

Hi Idrascic,

No, unfortunately that’s not my plan. I just want to move the dot to the decimal place. It works if I just put in the custom label “kWh” instead of the unit kWh electric (calculated), because then the unit **isn’t** calculated. With a calculated unit, I can’t seem to move the point of the decimal place, I can only specify the decimal places after the point or change the unit.