Forum Discussion
Aggregation on rows with user selected filters
Super UserCan you share what rows and columns would correspond to your initial example? I'm having trouble matching up this spreadsheet with that example.
Sure!!
Find below an image with a simple example. One offer, one feature (just T_Max) and two type of offer: INC (user selected it as type offer1) and INP (user selected it as type offer 2).
Left side is the spreadsheet and right side is the initial example (what the report should show):
So the mapping from the spreadsheet I uploaded would be:
A: Num_Offer is column Offer of initial example
B: Version. After applying concatenatex this is Revisions of initial example.
C: Offer Type. This is the type of offer and it is used to know where to put values of features columns D and E of spreadsheet.
D-L: This is are a few features of the offer. The name of the feature is the value of column B of the initial example. Values from D-L (spreadsheet) are taken into columns D-E (initial example) based on the offer type selected by the user as the image above shows.
- AlexisOlson
If you unpivot the features and define a custom column that groups the versions, this should be doable.
See attached.
I see your approach but the value of the feature for offer type 2 should be included when grouping. For T_MAX, version 6 changes from 150 to 150000 when comparing INC with INP. But the report shows two rows for 6 (empty -> 150000 and 150 to empty)
I also changed the value for 12 and the same:
As far as I can see, the value for offer type 2 should be included for grouping. And this means, combinations of types should be created as well. And this leads us to the original approach.
Am I correct?
- AlexisOlson
You'll have two rows regardless (either "6" and "9" or else "6" and "6,9"). The advantage of the way I did it is that the version strings can be pre-calculated. If you can come up with a better approach, then go for it.