Custom value for numerical values in member criteria of user dimensions
As stated in this comment, custom values are currently only able to handle string/text dimension members. This hinders our ability to use user dimensions for numerical dimension members, in particular creating price ranges. The ranges are important tools for our user base to summarize data using segments. Because of this, we currently have to either ensure that there are sentinel rows in the dataset that contain our target boundaries or we have to use another data abstraction like a calculated column that either defines the range or awkwardly converts the number to a string. Without the sentinel rows, if the data does not contain a row with the boundary value, the member is not included in the dimension. For example, if there was a price range from 60 to 80, if there is not a row with the exact price of 60, the member does not show up and I am not able to see the count of items price between 60 and 80 even if there are rows within the range.
User dimensions provide an important layer of meaning on top of the data we make available for our user base. It allows them to dynamically define groups of data that has more real world meaning for their stakeholders. Since a vast amount of the data that we want to show is numerical in nature, neither we nor our users can understand that this would suddenly break down when dealing with numerical data. Therefore, I would like to see this functionality expanded to allow for custom values when defining member criteria.
Comments
Please sign in to leave a comment.