Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I need to aggregate...
 
Notifications
Clear all

I need to aggregate the result in the data cube. How do I achieve this?

1 Posts
1 Users
0 Likes
299 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  

Step 1: Click on line and click on the settings icon. (Refer to the image below).

1672048160-linesetting.png
Step 2: Select 'Aggregate' operation from the popup. Then aggregate is added in between the 'sheet' and 'result'. (Refer to the image below).  
1672048186-aggregatedc.png
Step 3: Click on aggregate and click on the settings icon. Configure aggregate popup will appear. Select the column names and aggregate positions from the dropdown. Click on save. (Refer to the image below).  
1672048211-aggregatedc1.png

Step 4: Click on results and click on the settings icon. 

Step 5: In the configure popup, select the column name and the display name according to the user requirement. 

Step 6: Click on 'Save'. 

Step 7: Click on 'Show Preview'.  

Step 8: In Results, aggregate data will appear. (Refer to the image below).  

1672048255-aggregatedc2.png

   
Quote
Share: