alda1
(Alex Needle)
November 9, 2023, 5:23pm
1
Hi,
I’m able read data from my PV about production as value “Yield yesterday”, it looks like this :
and second information is “Yield today” and it looks like this :
I want make a bar graf about production for each day, but not clear for me how to do it.
Please can you help me ?
Thank you
Alex
Jostein89
(Jostein)
November 9, 2023, 5:59pm
2
Mine looks like this. Then I use the total production from each inverter.
config:
chartType: month
label: Solcelle prod mnd
order: "0.1"
period: M
sidebar: true
slots:
dataZoom:
- component: oh-chart-datazoom
config:
show: true
type: inside
grid:
- component: oh-chart-grid
config: {}
legend:
- component: oh-chart-legend
config:
show: true
series:
- component: oh-aggregate-series
config:
aggregationFunction: diff_last
dimension1: date
gridIndex: 0
item: Inverter_AlltimeEnergy_KW_10kW
name: 10kW
service: rrd4j
stack: one
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: diff_last
dimension1: date
gridIndex: 0
item: Inverter_AlltimeEnergy_KW_6kW
name: 6kW
service: rrd4j
stack: one
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: diff_last
dimension1: date
gridIndex: 0
item: Inverter_AlltimeEnergy_KW
name: 3,6kW
service: rrd4j
stack: one
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: diff_last
dimension1: date
gridIndex: 0
item: gSolcelle_E_tot
name: Total
service: rrd4j
stack: two
type: bar
xAxisIndex: 0
yAxisIndex: 0
tooltip:
- component: oh-chart-tooltip
config:
show: true
xAxis:
- component: oh-category-axis
config:
categoryType: month
gridIndex: 0
monthFormat: short
weekdayFormat: short
yAxis:
- component: oh-value-axis
config:
gridIndex: 0
max: "190"
min: "0"
name: kWh
alda1
(Alex Needle)
November 9, 2023, 6:04pm
3
Thanks
looks very nice, let me check.
Is it possible place into one day into two bars a total production and total consumption ?
Jostein89
(Jostein)
November 9, 2023, 6:18pm
4
config:
chartType: month
label: Strømmåler mnd
order: "0.1"
period: M
sidebar: true
slots:
dataZoom:
- component: oh-chart-datazoom
config:
show: true
type: inside
grid:
- component: oh-chart-grid
config: {}
legend:
- component: oh-chart-legend
config:
show: true
series:
- component: oh-aggregate-series
config:
aggregationFunction: diff_last
dimension1: date
gridIndex: 0
item: Strommaler_kWh_tot_import
name: Import
service: rrd4j
stack: one
type: bar
xAxisIndex: 0
yAxisIndex: 0
- component: oh-aggregate-series
config:
aggregationFunction: diff_last
dimension1: date
gridIndex: 0
item: Strommaler_kWh_tot_export
name: Eksport
service: rrd4j
stack: two
type: bar
xAxisIndex: 0
yAxisIndex: 0
tooltip:
- component: oh-chart-tooltip
config:
show: true
xAxis:
- component: oh-category-axis
config:
categoryType: month
gridIndex: 0
monthFormat: short
weekdayFormat: short
yAxis:
- component: oh-value-axis
config:
gridIndex: 0
name: kWh
1 Like
alda1
(Alex Needle)
November 9, 2023, 6:37pm
5
WOW
THANKS a lot
problem is that I think it’s day to day difference :
¨
edit: I changed to maximum and looks ok
1 Like
alda1
(Alex Needle)
November 9, 2023, 7:00pm
6
one additional question,
is it possible have a bar as sum of two values ?
like production1 = 5kWh (blue) production2 = 2kWh (green), complete bar = 7kWh ?
alda1
(Alex Needle)
November 9, 2023, 7:26pm
8
ohh, sorry my error. I thought it was one over second.
But for me not working
looks like it’s working only when value is still increasing, but for me goes to zero in midnight or hold a value complete day
alda1
(Alex Needle)
November 9, 2023, 7:44pm
10
I already found a reason. Now it’s solved. Must change again to :
thanks again
1 Like
alda1
(Alex Needle)
November 10, 2023, 3:21pm
11
I want ask one more question. I want show in the graph sum of two items. Is it possible make a sum directly in the graph definition somehow or I must make a new special sum_item for this sum and then make a graph from this sum_item ?
Jostein89
(Jostein)
November 10, 2023, 4:01pm
12
I use Number:SUM on the group I want to show. See first code above for the use of gSolcelle_E_tot
Group:Number:SUM gSolcelle_E_tot "Måler inverter" <solarplant> (gService) ["Inverter"]
alda1
(Alex Needle)
November 10, 2023, 4:06pm
13
not clear for me where to place. This Group I will place into chart page code ?
Jostein89
(Jostein)
November 10, 2023, 4:35pm
14
I have a Group containing all three values I want to Sum, if you then use Group:Number:SUM in the definition of the group, you can use the group name in the chart
Jostein89
(Jostein)
November 10, 2023, 4:53pm
15
You probably have to wait until tomorrow before it starts to show, it does not sum up past values, if I am not mistaking.
alda1
(Alex Needle)
November 10, 2023, 4:53pm
16
ok, I defined like this :
where I will place a group name ?
Jostein89
(Jostein)
November 10, 2023, 4:58pm
17
Then add the Items you want to SUM to this Group, and use Group name in bargraph instead of Item name
1 Like
alda1
(Alex Needle)
November 10, 2023, 5:02pm
18
I have only two items defined like this :
and
so parent groups names are different
is it correct ? or ?
Jostein89
(Jostein)
November 10, 2023, 5:07pm
19
I have three inverters in this one group, see images
alda1
(Alex Needle)
November 10, 2023, 5:11pm
20
how did you created this group ?: