If you have a list of data that you want to group and summarize, you can do this easily in the Prepare room of Lumira. We do not have to go back to the data source to create the new groups nor use Pivot tables like in Excel. Once we define the Groups we can also use it for building Hierarchies !

 

There are two methods to Group,

1) by Selection

2) by Range

 

Both these options are available from the Data Actions panel which appears after you select a dimension. Located on the right side of the application and sometimes you would need to scroll to the end to find it 🙂 .

 

1) Group by Selection

 

Used when the values are discrete in nature or if there are less values that need to be grouped.

/wp-content/uploads/2016/05/1_948849.png

 

2) Group by Range

 

Used when the values are continuous in nature or if there are many values that need to be grouped.

/wp-content/uploads/2016/05/1_948849.png

Group by Range can used for Date fields as shown above and for Numeric fields as shown below,

/wp-content/uploads/2016/05/1_948849.png

In both these cases, there will be a new column that would be created with the new groups.

 

For detailed instructions to Group data, please refer to the link Create groups: SAP Lumira 1.28 – YouTube

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Konstantin Kudymov

    Hello,

    Thanks a lot for the great article!

    I have a question on a Group by Range function – as I see resulted column has an alphabetical sorting, which is not really great when you dealing with numbers.

    Please see attached picture, I put the right numbers on bars – but I have no idea how to keep them sorted by interval number.

    Hope you could help to clarify it

    /wp-content/uploads/2016/06/2016_06_09_15_11_00_971415.png

    (0) 
    1. Varun Anand Post author

      Hi Konstantin,

      Thank you for the feedback. Please post this question on a different thread in the forum. I would be able to answer it better and can be accessed by others also.

      Thank you,

      Varun Anand

      (0) 
    2. Varun Anand Post author

      Hi Konstantin,

      Not sure if you were able to resolve this issue. But a simple step would be to use the Replace function in the Prepare room to get your desired results.

      Please let me know if there are any questions or comments.

      Thank you,

      Varun Anand

      (0) 

Leave a Reply