Smart columns as dimensions in agg. matrices

Follow

Soren Staun

• January 15, 2020 12:15

As a developer

I want to be able to use smart columns as dimensions in aggregation matrices

So That define my own flexible dimensions letting the smart column decide which dimension the element should be sorted into.

Benefits I cannot do this today. Only option is to export the smart column to excel and import it on another type of field on all the elements that should use it.

Acceptance Criteria 

1. Create a smart column
2. Add it as dimension to an aggregation matrices if the types match what's on the dimension stack currently.

Customer / Originator Banks

Priority High

2

• 

  Soren Staun

  • January 15, 2020 12:18

  Example of use: I have created a smart column that "buckets" all my percentages in intervals so that 0-10 is 10, 11-20 is 20, etc. I would love to be able to use this smart column as a dimension in my aggregation matrix which would allow me to bucket a graph instead of having a graph with lots of percentages spread all over (33,35,36,38,40,56,96,98) -> (40,60,100). This technique is commonly known as "buckets" when doing graphs and even if the graph type didn't support it, this approach would allow me to do it.

  0

  Comment actions Permalink
• 

  Matthew Dodd

  • January 15, 2020 12:44

  Agreed! Another version of this would be to add facts to the levels creator.

  i.e. you can currently group by a number field.. Why can't that number field contain some logic?

  (You can already work around this by creating a custom aggregation, if you're desperate?)

  Matt.

  1

  Comment actions Permalink
• 

  Soren Staun

  • January 29, 2020 07:42

  Matt, and by custom aggregation you mean matrix with custom SQL? (which is black magic to 99% of MooDlers, but yes :) )

  1

  Comment actions Permalink

Please sign in to leave a comment.