# Fixed

&#x20;Returns a fixed value specified by the 'value' parameter.\
&#x20;       @param value Type can be string or number

This function is helpful when a user wants to get a fixed value from a dataset (or set of column values).

### Example 1:&#x20;

Step 1: Create an empty **fixed\_example** using AIOps studio as shown in the below screenshot.

![Empty 'fixed\_example' pipeline](/files/-Mc_fFcaO1KWfxQ_qqzx)

Step 2: Add the following pipeline code/commands into the above-created pipeline as shown in the below screenshot:

You can copy the below code into your pipeline and execute that in your environment.\
\
\&#xNAN;*`##### This pipeline creates a list of rows with sales amount (int values) for each month`* \
*`##### using AIOps studio.`*\
\
*`##### RDA function fixed is used to demo this example (along with groupby, sum)`*\
*`##### TOTAL is used as a variable on which sum is performed to get the total sales`*\
*`##### amount for all six months (RDA uses agg = "sum" to calculate sum of all sales`*\
*`##### and provide the output of the total amount. Here TOTAL is used as an additional`*\
*`##### dummy column to allow RDA to calculate the sum.`* \
\
*`@dm:empty`* \
*`--> @dm:addrow amount = 10000 & month = 'Jan'`*\
*`--> @dm:addrow amount = 15000 & month = 'Feb'`*\
*`--> @dm:addrow amount = 11000 & month = 'Mar'`*\
*`--> @dm:addrow amount = 18000 & month = 'April'`*\
*`--> @dm:addrow amount = 8000 & month = 'May'`*\
*`--> @dm:addrow amount = 10000 & month = 'June'`*\
*`--> @dm:map to = "TOTAL" & func = "fixed" & value = "TOTAL"`*\
*`--> @dm:groupby columns = "TOTAL" & agg = "sum"`*\
*`--> *dm:filter * get TOTAL, amount`*<br>

![Pipeline code is added to and saved.](/files/-McfT4uSfgp-6KzLJ3Lf)

Step 3: Click verify button to make sure syntax and pipeline code is correct (as shown below)

![AIOps Studio RDA verifies pipeline code without any errors.](/files/-McfTe2HiJ3wljb2pgyf)

Step 4:  Click execute button and execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

![AIOps studio executes pipeline code without any errors](/files/-McfUQUGyYySd0j3lxg8)

Step 5: RDA uses the dm function 'fixed' to use a dummy column across all the available rows and provides a sum of 'amount' columns (which are defined in int') and provides an aggregate/sum value in the amount column after pipeline execution as shown in the below screenshot.

&#x20;

![pipeline code uses RDA function 'fixed' to calculate sum of all amounts and display the amount.](/files/-McfXcL4Ds4dq7tUnARW)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cloudfabrix.io/rda/rda-userguide/rda-aiops-studio/examples-jupyter/data-mapping-cfxdm-dm-functions/fixed.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
