Variable

The Variable feature in Lumenore empowers user to create custom variables from your existing data columns. User can mark these custom variables as attributes, metrics, or Key Performance Indicators (KPIs). These calculated fields help user to perform advanced data manipulations and visualisations with ease. Using the formula bar, user can define these variables with SQL or LQL (Lumenore Query Language) functions, making it possible to carry out complex calculations without needing deep technical expertise.

User can also create new variables from existing ones. In the formula editor, just drag and drop or double-click on your existing variables to use them in new calculations. You can apply various functions to these variables, giving you even more flexibility to tailor your data analysis exactly how you need it.

For example, a company might create a custom KPI to measure the success of a new marketing campaign by combining metrics like web traffic, conversion rates, and social media engagement. This flexibility allows users to focus on the metrics that most matter to their unique business goals.

Generate AI descriptions:

Click the “Generate AI Descriptions” button to let AI automatically create clear, human-friendly descriptions for each column using the column name and its context.

To Add Variables:

Step 1: Proceed by clicking the “+ Add Variables” option.

Step 2: The calculated Variable window appears, where the user can create the derived variable from the uploaded data with the functions.

Step 3: Select ‘Validate‘ to preview the results.

• Users can modify the aggregation to Sum/Average/Count/Count Distinct/Min/Max.
• If the data pertains to dates, switch to ‘Is it a Date?’ for appropriate handling.
• Utilize ‘Sort’ to arrange derived measure data as required.
• Specify the unit of measure (%/decimal/$) for calculating the measure.

Then, “Save” & “Publish” variables.

To edit and delete the existing variable:

• Click the “edit” icon to edit the variable.
• Click the “trashcan” icon to delete the variable.

Note: Variables created using Lumenore Query Language (LQL) are not supported in Lumenore Ask Me and cannot be used within its queries.