736 questions
0
votes
1
answer
39
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
0
answers
21
views
Need help in creating a calculated field in Google Data Studio in Pivot Data
I am working on Looker Studio. I am trying to plan for my new project and I have a table which has following fields
Employee name, Date, Current Capacity(range of 0-1). I am accepting the user input ...
- 1
0
votes
1
answer
64
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
0
answers
19
views
How to set group by at tableau
i have a code like this in my calculated field.
{FIXED [CC Receiver], [Platform]: COUNTD(IFNULL(DATE([Date]), NULL))}
basically is i want to know how many dates per month for cc receiver + platform.
...
- 61
0
votes
0
answers
40
views
Problem with level of detail expression (LOD)
I have a table called Patients in tableau that has the following fields
Patients
phone
name
sex
Parsed age
email
patient
Patient is the primary field and is the unique identified. The use case I'm ...
- 1
0
votes
0
answers
66
views
LookerStudio calculated field : How to calculate the average age based on distinct code_id values in SQL?
I am trying to calculate the average age from a table by using a calculated field. The formula I wrote is as follows:
ROUND(AVG(YEAR(CURRENT_DATE) - YEAR(date_naissance)), 0)
This works fine for ...
- 67
0
votes
0
answers
92
views
Piping calculated values into form fields for API data pull (calculated fields/text box w/ @CALCTEXT)
I am working on a longitudinal survey and need to use conditional logic to create fields for our API data pull. There are two scenarios where I need this to work:
Phone: return mobile_phone if ...
0
votes
1
answer
105
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
46
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
68
views
Why can't I update a memo field AsString() in OnCalcFields in state dsInternalCalc?
procedure TDataModuleProviders.FTPDataCalcFields(DataSet: TDataSet);
begin
inherited;
with DataSet do
begin
if (State = dsInternalCalc) then
begin
FieldByName(SProvFTPPassword)....
- 9,056
0
votes
0
answers
66
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
171
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
27
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
34
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
113
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