Statistiques mensuelles

[jeannot45]

Bonjour,

J'ai fait une petite application pour gérer ma consommation d'électricité.

Je relève tous les jours mon compteur et calcule le cout journalier de la consommation.

Mon objectif : je récupère dans un slice les données journalières des relevés que je regroupe par année et par mois. Je souhaite faire le cumul par mois des couts journaliers. Dans le "Group aggregate" le champ contenant le cout journalier n'apparait pas et l'affichage ressort l'ensemble des données sans faire de cumul. Autrement dit, j'ai autant de lignes que de jour dans le mois.

Comment gérer ce problème.

Merci à tous

[Aurelien · Accepted solution]

Hi @jeannot45 

You may prefer using English language for a fast answer 🙂

For English-speaking persons:

"I made a small application to manage my electricity consumption.

I read my meter every day and calculate the daily cost of consumption.

My objective: I retrieve in a slice the daily data of the readings that I group by year and by month. I want to cumulate the daily costs per month. In the "Group aggregate" the field containing the daily cost does not appear and the display shows all the data without adding them up. In other words, I have as many lines as there are days in the month"

---

@jeannot45 wrote:

Dans le "Group aggregate" le champ contenant le cout journalier n'apparait pas

---

Can you make sure this column is set with type "Decimal"? (peux-tu vérifier que la colonne est de type Decimal?)

[Aurelien · Accepted solution]

---

@jeannot45 wrote:

How show the symbol "€" after the sum ?

---

You may prefer using the type Price instead of Decimal 🙂

In the option of this type, you can choose the currency, such as € or $ or any other currency 🙂

---

@jeannot45 wrote:

Thanks for your traduction of my post but the utilisation of the english langage is so far that is difficult for me. But, I shall try.

---

Pour cette partie, j'utilise allègrement DeepL, c'est le meilleur outil que j'aie rencontré : ça fournit une traduction très idiomatique, l'esprit est clair, et je n'ai pas encore rencontré de traduction approximative dans mon usage quotidien 🙂

[Aurelien · Accepted solution]

Hi @jeannot45 

You may prefer using English language for a fast answer 🙂

For English-speaking persons:

"I made a small application to manage my electricity consumption.

I read my meter every day and calculate the daily cost of consumption.

My objective: I retrieve in a slice the daily data of the readings that I group by year and by month. I want to cumulate the daily costs per month. In the "Group aggregate" the field containing the daily cost does not appear and the display shows all the data without adding them up. In other words, I have as many lines as there are days in the month"

---

@jeannot45 wrote:

Dans le "Group aggregate" le champ contenant le cout journalier n'apparait pas

---

Can you make sure this column is set with type "Decimal"? (peux-tu vérifier que la colonne est de type Decimal?)

[jeannot45]

Hi @Aurelien

Thanks for your traduction of my post but the utilisation of the english langage is so far that is difficult for me. But, I shall try.

After verification, the type of the column "Cout Jour" was "Number". After change, all is good. I can use this column in Group aggregate.

May I ask to you one question :

How show the symbol "€" after the sum ?

Thank you for your help

[Aurelien · Accepted solution]

---

@jeannot45 wrote:

How show the symbol "€" after the sum ?

---

You may prefer using the type Price instead of Decimal 🙂

In the option of this type, you can choose the currency, such as € or $ or any other currency 🙂

---

@jeannot45 wrote:

Thanks for your traduction of my post but the utilisation of the english langage is so far that is difficult for me. But, I shall try.

---

Pour cette partie, j'utilise allègrement DeepL, c'est le meilleur outil que j'aie rencontré : ça fournit une traduction très idiomatique, l'esprit est clair, et je n'ai pas encore rencontré de traduction approximative dans mon usage quotidien 🙂

[Florent_GESTIN · Accepted solution]

I love deepL too. I have been using it for several years

[jeannot45]

Hello Aurelien

I apologize for the delay in responding but I was away for the whole period.

Thank you very much for your help and for the name of the translator