731 questions
1
vote
1
answer
57
views
Calculation per game in Tableau
I'm hoping to gather some stats for players in a sport - Errors per game.
At the moment I have a stat "Total Errors" and a calculated field "Match ID" using "Year", "...
0
votes
2
answers
92
views
Calculated Field - Subtract two percentages for Percent Point Difference?
I am simply trying to add a calculated field to a pivot table, that subtracts two percentages. I'm trying to get the percent point difference between a "Name" average and "State" ...
- 23.5k
0
votes
1
answer
42
views
AWS Quicksight: ArgMax Calculated Field
I would like to write a calculated field which returns the value of a string column corresponding to the maximum of a date column, subject to the date being between two parameters. So, for example, if ...
- 1,310
1
vote
1
answer
30
views
Date Calculated Field is not showing in parameter in Tableau
I am trying to create a date parameter based on a calculated field.
Here is the calculation:
SetMinDate:
DATE(MIN([Gift Date]))
but when I go to create the paramenter, it doesn't appear as an option ...
- 31
0
votes
0
answers
20
views
Writing Calc fields in Workday based on Reporting > Report Fields and Values
I need to create a calc field to put on a report that is based on the Revenue Categories DS and Report Category BO. I know how to navigate to the field that I want on my report - the problem is how to ...
- 1
0
votes
1
answer
143
views
Performing Calculations Between Custom Meta Fields in Crocoblock JetEngine and Displaying Results Using Native JetEngine Shortcodes
I have Elementor Pro, JetEngine, and the JetEngine Calculated Callback Add-on (it's gitgub) installed on my local WordPress site. Using the JetEngine plugin, I manually created a Custom Post Type (CPT)...
- 21
0
votes
1
answer
52
views
Calculation of Runtime only once in AWS Quicksight
I hope somebody can help me. I'm new to AWS Quicksight and trying my first steps.
I have a table with two columns. First column contains a unique ID, second column contains a Runtime.
What I'm trying ...
- 3
0
votes
1
answer
111
views
Calculated field in Pivot table using min of date
I have a pivot table that returns the min of a date per category . Can I have a calculated field that works like this: date - Today
I tried a calculated field but couldn't select the min of date to ...
0
votes
1
answer
84
views
Update a date field in selected records with a calculated, relative date
The end result I am looking for is to have a query that will find specific records in Table1, use a field in joined Table2 to retrieve a day of the week, use a formula to determine the next occurring ...
0
votes
1
answer
203
views
Converting currencies to USD in as calculated field in Workday
I am trying to convert all amount in different currencies aside to all amount in USD. I selected Total base pay - amount as the source field, USD as the target code, selected to add currency code, etc....
0
votes
0
answers
65
views
Tableau Calculation - Week Parameter & calculated field
I've been trying to display return on marketing investment ROMI for the CURRENT SELECTED WEEK (CW) in my table. I'm using a parameter that displays data by week number - all other calculated fields ...
- 17
0
votes
0
answers
104
views
how to create multiple select parameter in tableau & combine columns
The dataset I use is like this
raw data
for example in a column balloon
The number 1 in the balloon column indicates that the warehouse has balloons, and 0 indicates that the warehouse does not have ...
- 1
0
votes
1
answer
282
views
Does including ‘today’ in the Datediff function mess up the automated calculation?
Background: I use RedCap to track expiration dates for temporary appointments in my department. The specific issue I am having is with a calculated field I use to track how many days are remaining ...
- 3
-1
votes
1
answer
33
views
Getting blanks when trying to calculate the current year avg. no of bins, how can i resolve this? Issue seems to rise when i put in the date argument
I want to create a measure for current year average no. of bins. I tried the below possibilities and all are giving blanks. i tested to see if it's an issue with my date column but when i filter the ...
1
vote
1
answer
54
views
Calculating the average time between StartTime and EndTime in VBA or in a calculated control. Then getting an average for many records
I want to get the average time between StartTime and EndTime in VBA or in a calculated control. Then get an average for many records.
I am using Access to build controls on a form that will show the ...
0
votes
1
answer
176
views
Tableau Sum is already an aggregation and cannot further aggregate
I’m trying to take the sum of the count of a column and it’s telling me sum is already an aggregate and can not further aggregate.
Attempt: Sum(Count of Cases)
The count of cases is a calculated file ...
- 33
0
votes
1
answer
130
views
How to create a calculated field in Tableau for Aggregated and Non-Aggregated Fields
I have a date field which is a calculated field ("SalesDate_current_month", this will give values True or False) from original date column (SalesDate). Trying to create a calculated field as ...
- 433
1
vote
2
answers
43
views
MySQL: Select and calculate values from next row
I have a little trouble here.
If i have the following table:
ID | Name | ini_day
-----------------------
1 | Juan | 1
2 | Nora | 5
3 | Pepe | 9
4 | Lara | 12
5 | Alex | 18
6 | Lily | 20
...
- 79
0
votes
1
answer
64
views
Calculating the percentage difference between today's patients count with yesterday's patient count in Tableau
My data contains patient ids (around 70) and their time and date of visit. The dates are from April 1 to April 15. I want to calculate the percentage difference between the patients of today vs ...
-1
votes
1
answer
80
views
Is there a function for changing text value to numeric value in a calculate field in a pivot table in Excel sheet?
I used a formula in the calculate field in a pivot table and it returned #VALUE! error stating "Function AVERAGE in parameter 1 expected number values but Box Office Revenue ($) is text and ...
0
votes
1
answer
236
views
REDCap, Calculated Text -- Apply Same Conditional Function to Several Fields at Once (e.g. print all labels for fields that the user picked "true" on)
I have a long survey in REDCap and we're wanting to generate a summary of all items the participant endorsed. They're all true/false.
So lets say the fields are named question1, question2,..., ...
0
votes
0
answers
33
views
Tableau Calculation Based on Filter
I have a dataset that contains details of customer policies. I am using two calculations below to calculate the percentage that have email preference vs Postal preference.
However there is also a ...
- 51
0
votes
1
answer
25
views
Excel Pivot calclated field
I am trying to this:
But it doesn't work - what do i do wrong?
i want to give every region a Target.
Is it even possible to do it via Calculated Field?
Hope someone could help me.
Thank you and have ...
1
vote
1
answer
253
views
Comparison between two identical tables in Quicksight
I'm looking for some assistance. Currently I have two tables (left and right) that have identical columns and coming from one source of data. The only difference being the left table is the count of ...
- 11
0
votes
1
answer
98
views
How to get 'Sum' working in Calculated field based on another calculation?
I have a set of data. I need to know if the agent has gone over 25.9 seconds in ACW, if so produce a 1 in the cell, then i want the total number of agents who have bene over this target to be ...
- 129
0
votes
1
answer
530
views
Calculated Field Custom Formula not working in Google Sheets Pivot Table
Here's a dummy spreadsheet of data and a pivot table
I've got data in column A (Person) and column B (CheckedIn).
People have CheckedIn values of between 0 and 6.
I want a Calculated Field to show a ...
- 31
0
votes
1
answer
1k
views
Looker studio calculated field formula (extremely diff)
I have a test that I administer and the results are represented in 3 columns: colA contains names of students and colB contains decision string which is either correct or incorrect, and colC contains ...
0
votes
0
answers
71
views
How to duplicate calculated fields while replacing the field from which they calculate in Tableau
I want to be able to take this calculated field (don't worry about the actual field)
COUNTD(IF [John Doe] THEN [response_id]
END)/COUNTD([response_id])
and create like 100 more calculated fields but [...
- 13
0
votes
1
answer
116
views
Add or Subtract Fields on a Create Razor Page and Display Result on Page?
Let's say I have a Model:
using System.ComponentModel.DataAnnotations;
namespace Test.Model
{
public class Balance
{
[Key]
public int Id
[Display(Name = "Invoice ...
- 183
1
vote
1
answer
40
views
power BI exclude Duplicate Row with condition
I have this table
which is a live connection from ssas to power BI
I want to count duplicate based on typeName and wher completeDate is blank
I wrote the folowing DAX
Duplicate = VAR Dup = COUNTROWS(...
- 1,747
1
vote
2
answers
46
views
Getting difference column in power bi
I want to create difference column using two tables Table 1 and Table 2 , I want to create Table 3 which is having difference of count column using DAX formula
- 43
0
votes
0
answers
51
views
How to remove the nulls that show up in the table that I created from my calculated fields
Nulls that show up in the table that I created from my calculated fields, I made calculated fields from already existing date columns called target and forecast dates. This is how the original data ...
2
votes
1
answer
61
views
Calculate textbox input Total times textbox input percent equals new input textbox total
I have looked up and down trying to figure this out, I am trying to make a simple calculation on change event with 3 textbox inputs
Cost of Item textbox
Discount Percentage which would be entered ...
- 23
2
votes
1
answer
218
views
How do write a calculated field in tableau to pick the latest record based on column criteria?
Date RefNum Value TxnType
Mar-23 SS 20 BillDoc
Apr-23 G4 40 BillDoc
May-23 HT 85 BillDoc
Jan-23 R3 3 Credit
Feb-23 R3 5 Credit
Aug-23 D7 10 Credit
Sep-23 D7 15 Credit
...
- 75
0
votes
0
answers
71
views
Changing a Tableau calculated field into a dimension
I have a field that is an approximate sales quantity per month that is called : [Sales Quantity / Week (Stock Unit)]. This field is a one value per product since it is an approximation calculated as:...
- 1
0
votes
0
answers
1k
views
Writing a IBM-Cognos expression to filter dates between custom ranges
I'm trying to write an expression in Cognos Analytics to return my data points within a certain range. My data is organized similarly such as in this picture with dates and names all the way back to ...
0
votes
0
answers
45
views
how can i visualized my 2023 parameter on tableau after i have found the year different
Tableau visualization
i tried this but 2023 column did not calculate rather just giving out negative values in tabeau
COUNTD(IF [Year] = 2013 THEN [Name] END) - COUNTD(IF [Year] = 2023 THEN [Name] END)...
0
votes
1
answer
374
views
Autofilling answers with conditional logic?
I have a 1x3 table that contains embedded fields. Here is the row below:
Row 1: Baseline | 3 Months | 6 Months
Each of these options (Baseline, 3 Months, 6 Months), are a field type of Multiple ...
0
votes
2
answers
1k
views
Google Sheets pivot table add column for value with no data
I have survey data on teacher quality with possible responses being 1-4. No one reported 1, so it won't automatically show in the pivot table I am trying to create.
This is what I'm working with. ...
- 15
0
votes
1
answer
2k
views
Creating a calculated field in a workday report
I would like to understand how I could create a new field called "Field 1" in my workday report.
The logic for this field is – if there is a "Yes" in "field 2" OR a "...
0
votes
0
answers
38
views
Can a Tableau filter be used in multiple ways simultaneously?
I have built a Dashboard that has two filter worksheets within it.
The first worksheet contains all the transactions for all the clients while the other Worksheet only contains Payouts.
What I am ...
0
votes
3
answers
514
views
Existing Sharepoint list to replicate
I am working for a company that has several sites. The two sites use different IT systems. I have a sharepoint list from company A that I need to replicate in company B. The list was done by someone ...
- 143
0
votes
0
answers
29
views
Using the display value of a dropdown in a mathematical equation (LiveCycle, Javascript)
I have three fields:
1: user selected dropdown(DD1).
2: calculated dropdown(CDD2) that is set based on the rawValue of DD1.
Note: All the display value's and the rawValue's of both DD's are numbers
3: ...
- 3
0
votes
2
answers
617
views
How to add calculated field to Django model
I am building a database system and am trying to add calculated field to model as well as the template. I want to field to automatically generate the result of to the values entered on two fields.
...
0
votes
1
answer
134
views
i am trying to modify this case statement in Tableau
CASE
WHEN [Metric Type] = 'FTE' THEN 'Per Student FTE'
WHEN [Metric Type] = 'GSF' THEN 'Per GSF'
ELSE NULL
END
I am getting an error message that an identifier is missing. how can I modify this ...
- 1
0
votes
0
answers
230
views
Problem with calculated fields in attached kbmMemTable
I have a delphi project which has two kbmMemtables, the first kbmMemtable1 has 4 data fields (ID, PRODUCT_NAME, QUANTITY, PRICE) and a calculated field TOTAL, the TOTAL field is calculated in the ...
0
votes
0
answers
1k
views
Google sheet pivot table calculated field with if statement
I'd like some help regarding pivot tables calculated parameter in google sheet.
I have a pivot table where i count how many instances are listed in data table.
In my data table i have a column with ...
0
votes
1
answer
61
views
automatic calculated integer fields in django models
I have model like this
class Product(models.Model):
name = models.CharField(max_length=150)
stock = models.IntegerField()
cogs = models.IntegerField()
def __str__(self):
return ...
0
votes
0
answers
245
views
Trying max() function on datetime field of format dd/MMM/yyyy:HH:mm:ss Z
I am trying to create a calculated field where i am using a column ,called "requestdatetime" and it is of data type datetime, to find the latest date .
Thus i used the function : max({...
1
vote
1
answer
79
views
Time travelling! How to calculate student grade on the fly?
I have the following school data, but I want to plot a line chart of say, no. of grade 3 students in each academic year. I am not able to do that since I only have the current grade for this academic ...
- 47