User Profile
Pierpaolo80
Advocate I
Joined 3 years ago
User Widgets
Contributions
Re: Help for create measure column with Sum of values between different tables (key: TIMESTAMP)
Hi Harish first of all thanks for your time! unfortunately I think your suggestion can't be applied to my needs. I don't need a measure but a new column where I can read the sum of all energy values taken from different tables (with same date) I need it as a column so I'll be able to represent it in a chart (x axis as calendar Date)Re: Help for create measure column with Sum of values between different tables (key: TIMESTAMP)
In the following img you can see the model of my datas This is the data sample from one of my table (dates and column title are in Italian but i think they could be easy to understand) In the following img one other table. In the previous imgs I tried to highlight the columns of the datas that I would like to add together by same dates (date column).Help for create measure column with Sum of values between different tables (key: TIMESTAMP)
Hi everybody am a very recent user of this SW and I never imagined that I would like it so much! I am facing a problem to which I cannot find a solution. I would like to be able to represent the energy consumption of a building. I have the datasets broken down for each individual plan and have uploaded them as separate files. Every single energy consumption is associated with a timestamp. The consumption of some floors of the building started earlier while the datas related to the top floors of the building are later (by a few months). After creating a Calendar table, I graphically represented the data of each single floor in the same chart but I would like to insert also the total consumption of the whole building by summarizing the floors' datas. How could it be possible? Is it possible to generate a new column (e.g. Building Total Energy Consumption) where values come from different tables (4 or more) with same timestamp as a condition? Someone can give me an Advice? thanks to everyone
