Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.2.0
    • Fix Version/s: 4.3.0
    • Component/s: UI
    • Labels:
    • Sprint:
      UP6 Sprint 1
    • Release Notes:
      Adds Calculate directive to the directives dropdown in Data Prep.
    • Rank:
      1|hzy13a:ayh

      Description

      As a user, I want to perform calculations on numeric data or string data.
      These directives can be specifically applied to data that is formatted as either Numeric or String.
      The system is able to recognize the type of data and present directives that are applicable to each of the formats.
      If the system is unable to recognize the type of data, all options are presented to the user, organized under the type of formats.

      Numeric Data
      As a user, I can perform the following calculation when my data type is Numeric.

      Operation Descripton Requires user input Expression
      Add Add a user-input value to the existing column or results can be organized in a new column Yes <column> + n
      Subtract Subtract a user-input value to the existing column or results can be organized in a new column Yes <column> - n
      Multiply Multiplies a user-input value to the existing column or results can be organized in a new column Yes <column> * n
      Divide Divides a user-input value to the existing column or results can be organized in a new column Yes <column> / n
      Modulo Calculate remainder of nearest product Yes <column> % n
      Exponent (math:pow) Elevate to the power Use a user-input value as exponent Yes math:pow(<column>, n)
      Absolute Value Map negative integers to positive and positive to positive No math:abs(<column>)
      Sin Trig sin function No math:sin(<column>)
      Cos Trig sin function No math:cos(<column>)
      Tan Trig tan function No math:tan(<column>)
      Arccos Trig arccos function No math:acos(<column>)
      Arcsin Trig arcsin function No math:asin(<column>)
      Arctan Trig arctan function No math:atan(<column>)
      Square Power of 2 No math:pow(<column>, 2)
      Square root Power of 1/2 No math:sqrt(<column>)
      Cube Power of 3 No math:pow(<column>, 3)
      Cube root Power of 1/3 No math:cbrt(<column>)
      Log Base 10 No math:log10(<column>)
      Natural log Base e No math:log(<column>)
      Round Nearest integer No math:round(<column>)
      Ceil Nearest integer up No math:ceil(<column>)
      Floor Nearest integer down No math:floor(<column>)
      Random Generate in range [0, 1) No math:random(<column>)

      String Data
      Numeric Data
      As a user, I can perform the following calculation when my data type is String.

      Operation Action Requires user input Expression
      Character Count Counts the number of characters in any rows and copy the results in a new column; the new column is named by default, but the user can edit the name (Name destination pattern and error handling is applicable) Yes string:length(<column>)

      The system is not able to recognize the data
      When the system is not able to recognize the type of data, I want to see all operations (order: string and then numeric ).

      Acceptance Criteria

      • The type of operations are organized and labeled based on the type of data to which they can be applied
      • In the submenu, "Calculate" is in its own section together with "Format" and "Custom JXL Transform"
      • On hover, the background of the menu item changes.
      • If the vertical space is limited and not all operations can be shown at once, the user is able to scroll through by clicking the top and bottom arrow (see mock up)
      • The line height for the items in the menu and submenu is 28px; if the items have a separator, the height is 32px
      • Error messages are handled using current visual pattern

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tbach Tony Bach
                Reporter:
                bhooshan Bhooshan Mogal
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: