in Technology by

What is a Calculated Field, and How Will You Create One?

1 Answer

0 votes
by

A calculated field is used to create new (modified) fields from existing data in the data source. It can be used to create more robust visualizations and doesn’t affect the original dataset.

For example, let’s calculate the “average delay to ship.”

The data set considered here has information regarding order date and ship date for four different regions. To create a calculated field:

  1. Go to Analysis and select Create Calculated Field. 
  2. A calculation editor pops up on the screen. Provide a name to the calculated field: Shipping Delay.
  3. Enter the formula: DATEDIFF (‘day’, [Order Date], [Ship Date])
  4. Click on Ok.
  5. Bring Shipping Delay to the view.
  6. Repeat steps 1 to 5 to create a new calculated field ‘Average Shipping Delay’ using the formula: AVG (DATEDIFF (‘day,’ [Order Date], [Ship Date]))


     
  7. Drag Region field to Rows shelf and SUM(Average Shipping Delay) to the marks card; the average delay for each region gets displayed.

Related questions

0 votes
    You can restrict the entry of data into a field by defining a for it a calculated values b volatile rule c. validation rule Select the correct answer from above options...
asked Dec 25, 2021 in Education by JackTerrance
0 votes
    Create a table “Employee” where field names will be EmpID, EmpName, Designation, Salary. Please answer fast. Please. Select the correct answer from above options...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
    Under Version control, how you will create a new directory in SVN?...
asked Feb 21, 2021 in Technology by JackTerrance
0 votes
    How will you create a dictionary using tuples in python?...
asked Nov 24, 2020 in Technology by JackTerrance
0 votes
    How will you create a dictionary in python?...
asked Nov 24, 2020 in Technology by JackTerrance
0 votes
    I have two integer values ta and thc and I'm making the percentage calculation for these two values and ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 24, 2022 in Education by JackTerrance
0 votes
    How is the render time calculated? (a) Date.Now() (b) Date.Now() - performance.timing.domLoading ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 23, 2021 in Education by JackTerrance
0 votes
    How will you create a Base64 encoder that encodes using the URL and Filename safe type base64 encoding scheme in Java8?...
asked Nov 8, 2020 in Education by Editorial Staff
0 votes
    How will you create a Base64 decoder that decodes using the URL and Filename safe type base64 encoding scheme in Java8?...
asked Nov 8, 2020 in Education by Editorial Staff
0 votes
    How will you create a Base64 encoder that encodes using the MIME type base64 encoding scheme in Java8?...
asked Nov 8, 2020 in Education by Editorial Staff
0 votes
    How will you create a Base64 decoder that decodes using the MIME type base64 encoding scheme in Java8?...
asked Nov 8, 2020 in Education by Editorial Staff
0 votes
    How will you create a Base64 encoder in Java8?...
asked Nov 8, 2020 in Education by Editorial Staff
0 votes
    How will you create a Base64 decoder in Java8?...
asked Nov 8, 2020 in Education by Editorial Staff
...