These are two of the options that you can use for data wrangling when you import a file for a story in SAP Analytics Cloud, according to the SAP Help Portal1.Data wrangling is the process of cleaning, structuring, and enriching raw data into a desired format for better decision making in less time2.

The custom expression editor is a tool that allows you to create or edit formulas and expressions for your data columns3.You can access the custom expression editor by clicking on the formula icon in the builder panel or by double-clicking on a column header in the data view3.The custom expression editor provides a list of functions and operators that you can use to manipulate your data, such as arithmetic, logical, string, date, and aggregation functions3.You can also use the custom expression editor to create calculated columns or measure-based dimensions from your existing columns3.

The transform bar is a tool that allows you to apply various transformations to your data columns, such as renaming, reordering, grouping, splitting, merging, or deleting columns4.You can access the transform bar by clicking on the transform icon in the builder panel or by right-clicking on a column header in the data view4.The transform bar provides a list of actions that you can use to modify your data structure, such as move left, move right, group by, split by delimiter, merge columns, or delete column4.You can also use the transform bar to change the data type or format of your columns, such as text, number, date, currency, or percentage4.

The Optimized Design Experience is a new design option for creating stories in SAP Analytics Cloud. It offers several usability improvements and performance enhancements compared to the Classic Design Experience.However, it also has some limitations and differences, such as the unavailability of some elements that are present in the Classic Design Experience1.

The following filter options are supported in the Optimized Design Experience:

Widget: This option allows you to apply filters to a specific widget, such as a chart, table, or map, that are based on the same model.You can use the Filter area in the Builder pane to pre-filter the data that the widget displays2.

Story: This option allows you to apply filters to all widgets in a story that are based on the same model.You can use the Story Filters tool in the Tools section to select dimensions or measures that you want to filter by2.

Input Control: This option allows you to add interactive filters to a story page that allow the story viewers to filter data, compare figures, and explore relationships directly from the page.You can use the Input Controls tool in the Tools section to select dimensions or measures that you want to use as input controls3.

The following filter options are not supported in the Optimized Design Experience:

Controls: This option is not a valid filter option in SAP Analytics Cloud. It may refer to input controls, which are supported, or chart controls, which are not supported. Chart controls are buttons that allow you to change the chart type, switch between absolute and relative values, or drill up and down in a hierarchy.Chart controls are available only in the Classic Design Experience4.

Section: This option is not a filter option, but a way of organizing a story into different parts based on a dimension. A section creates a separate page for each member of the dimension, and displays the same widgets on each page with the data filtered by the section dimension. Sections are available in both the Optimized and Classic Design Experiences.

1:Choosing Between Optimized and Classic Design Modes - SAP Learning2:Filtering Data in Optimized Design Mode - SAP Learning3:Using Input Controls - SAP Learning4:Chart Controls - SAP Learning: [Creating Sections - SAP Learning]

You can add a section to a canvas page in a story. A section is a container that holds one or more widgets and can be used to group related content or apply filters. A digital boardroom, a table, and a chart are not valid targets for adding a section; they are either different types of presentations or widgets that can be added to a section. Verified Reference: [SAP Analytics Cloud - Sections]

When you create a story using a file as the data source, you automatically create an embedded dataset. A dataset is a collection of data that is imported into SAP Analytics Cloud and can be used in a story. An embedded dataset is unique to that story and cannot be shared outside the story or refreshed.You can transform or wrangle the data in the dataset to meet your story needs in the Data Preparation area

You can use table templates and styling rules to change the formatting of a table in the Styling panel. Table templates allow you to apply predefined formats to tables, such as alternating row colors, grid lines, and font sizes. Styling rules allow you to apply conditional formatting to tables, such as changing the background color, font color, or icon based on certain criteria. In-cell charts and thresholds are not available in the Styling panel; they are options that can be enabled or disabled in the Builder panel. Verified Reference: [SAP Analytics Cloud - Table Formatting]