Stack Overflow
Stack Overflow

Questions tagged [calculated-columns]

A calculated column is calculated from an expression that can use other columns in the same table

A calculated column is calculated from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators. The expression cannot be a subquery.

2235 questions
0
votes
1 answer

Sharepoint Library "Name" column not visible in calculated-column dropdown list

In Modern Sharepoint I created a Document Library by New>Document Library and then uploading *.png files. They are stored in a Column Name called Name (linked to document with edit menu). This can be seen in Settings>Edit View Now I want to create a…
thb
  • 167
  • 1
  • 1
  • 7
0
votes
1 answer

R - select years within a data frame based on calculated values from another columns

I'm rather stuck. I need to perform some calculations on selected years, which are different for different locations based on additional calculations. I have a data frame that looks like the following sample df: t0 <- 2017 tf <- 2046 pH_drift <-…
ebb
  • 274
  • 2
  • 6
  • 16
0
votes
1 answer

Can I add a calculated boolean column to an Elasticsearch Kibana query from data from another query?

Let's imagine that we have an Elastic index and we want to get all the documents of that index and a calculated field with the result of a filtering a different Elastic index. I will better explain that in SQL code so even if Elastic is NoSQL, I can…
Roger Campanera
  • 337
  • 3
  • 12
0
votes
2 answers

Sum each four rows in a column

I'm a beginner in R and I really need your help. I'm trying to get a new dataframe that stores the sum of each five rows in my columns. For example, I have a dataframe (delta) with two columns (A,B) A B 2 3 1 2 3 2 4 5 3 7 5 6 2 5 …
Charlon16
  • 3
  • 2
0
votes
0 answers

How to embed a ranking function into the AllPrevious Function for a calculated column in Spotfire

I am trying to make one equation from the two below, but either I am missing something completely simple, or there is a trick to embedding a ranking function into the "AllPrevious" function in Spotfire VAR_X = (Rank([D] /…
NightLearner
  • 295
  • 1
  • 7
  • 21
0
votes
0 answers

Aplicate a complex operation on a column to create a new dataframe in R

I have a dataframe that looks like the the following, lets call it…
Valeria Arango
  • 287
  • 1
  • 2
  • 8
0
votes
1 answer

SQL - Calculated Column

I have a table which shows me a stock ticker, asofdate, open, close. I have created a computed column called daily PL which is simply the daily close-open. ,(close-open) AS daily_pl I cannot figure out the logic of using the {open} from the first…
TommyK
  • 5
  • 3
0
votes
1 answer

Different results when using calculated column and measure in PowerBI

I created a calculated column and measure. They should bring same result. But when creating visuals I get different view. My calculated column: if [CostPrice] = null then 0 else [AmountWithDiscount] - [CostPrice] And visual with this column: When…
vytaute
  • 1,260
  • 4
  • 16
  • 36
0
votes
1 answer

Deterministic epoch to date

i have a bigint column in a table containing unix/epoch times (excluding milliseconds); eg. 1610278178 (2021-01-10T11:29:38+00:00) i want to have a persisted computed column which converts epoch to date (so not datetime!) i came up with this and it…
Eddict
  • 43
  • 7
0
votes
1 answer

Typed Dataset Calculated Column using Linq

I have a strongly-typed DataTable returned in a strongly-typed DataSet from a database query. The DataSet is subsequently passed to a ReportViewer to display a chart based on some aspects of the data. I've added an extra column to the dataset and…
Nick
  • 25,026
  • 7
  • 51
  • 83
0
votes
2 answers

How to add query results to table in SQL?

I am trying to add the results of a query to an existing table, dependent on the values of an existing column. For example, using the table…
RIchXIII
  • 15
  • 3
0
votes
2 answers

RMSE between all value with same hours with pandas

I have two dataframe: the first represents the output of a model simulation and the second the real value. I would like to compute the RMSE between all the value with the same hours. Basically I should compute 24 RMSE value, one for each hour. These…
diedro
  • 511
  • 1
  • 3
  • 15
0
votes
1 answer

How to create a single column with all the relevant text?

I have a dataset enter image description here and I want to create a single column with a title and text. I tried to write a code like that: df['text'] = df['title'] +" "+ df['text'] #Delete all the other columns. del df['title'] # added to text…
ma_brr124
  • 11
  • 3
0
votes
2 answers

Can I create an email for the user based on input for the first and last name using postgreSQL?

I am pretty new to Postgres, and I am making a mock database that manages students for a university so I can get a better understanding of how Postgres works. I am creating a student table that has columns for student id, enrollment date, grad year,…
backward forward
  • 429
  • 3
  • 17
0
votes
2 answers

MYSQL Update using SUM the same table

Hi so sorry for I know this just to basic. simple update only using sum on the same table. I need to get total_tbl +-- month1 --- month2 --- month3 --- total --+ | 3 3 5 | | 5 3 5 …
John Arzaga
  • 103
  • 1
  • 1
  • 11
1 2 3
…
99 100