Let’s dive deep into report building! We will walk you through the elements, set up and how to create your first report. Make sure that you have read previous article on how to create a report and how to upload data.
Once you have completed the set up that we covered in the previous guides you should have a blank editor, like this 👇
If you skipped the previous guide about available ajelix elements you can read it here.
Step 1: Understanding editing
Simply pick the first element you want to see in your report. Once you click on any element it will appear on your report and you will see editor.
On the left side you can see editor and on the right you see report preview. In report preview you can drag and drop the elements to rearrange them. By clicking on each element in report preview you will open the element settings. Each element has it’s own element settings where you can:
- Rename elements
- Change color, size, alignment
- Choose columns from you dataset
- Do calculations with your data
- Add, remove filters
- Add explanations or comments. This is the part where you can add small descriptions and when sharing the report other people can see your thoughts.
- Arrange data descending or ascending order.
- Explain charts with AI to reveal correlations and different trends in your data.
Step 2: Set up element settings
Now let’s set up the first element settings. We picked the card element that we will start editing, here’s also a picture to help you track the editing.
Customize the appearance of your element
1. The first step let’s you rename your element as you like.
2. You change the size of the number.
3. Set up element background color, title color or number color.
4. Pick the right, center or right alignment for your card numbers.
5. Format the number so it would display the correct formatting. For example, euro, dollar, decimal, thousands or any other formatting. Click on the questions mark to open the table with custom formatting or visit this article. Simply copy the format column to see the desired output in the card.
6. You can resize the element by dragging the right corner in any direction you want.
Set up the calculations for your element
Once you’ve done the customization part, it’s time to set up calculations for the card.
Here’s how to set up the element with your data file:
1. In this field you will see all columns from your data file. Simply, pick the column that you want to calculate.
2. This is calculation field, where you can choose the calculation for the column that you picked. There are several options available:
- Sum
- Count
- Average
- Max
- Min
- Distinct Count
- Median
- Mode
- Standard Deviation
- Variance
Just pick one of the calculations and the element will automatically update the value for you.
3.,4. The next field is filter where you can apply filters so that the card would calculate value based on the filters you apply. In our example, we applied filters to calculate profit only for January and February. You can add several filters for more specific result.
5. Now you can add comments or explanations for your colleagues or any report users that will view the report.
Click Save and add the next element. If you can’t save the report it means that you have a freemium plan that let’s you create reports without the ability to save them. If you enjoy our tool consider subscribing for a monthly or yearly plan (this way you will save 30%) to unlock the premium features.
Step 3: Add another element
Once you’re done with the first element you can click on Add element in the editor and pick the next element.
Choose from the element list and start the next element set up.
Step 4: Save, Preview, Share
Once you’re report is ready you can save it, preview it to see how it looks in a full width by pressing on the View button at the bottom of editor. You can also share the report with link to others or give editing option by adding other users with email.