Hi Team, I have two questions regarding report cre...
# gooddata-cloud
r
Hi Team, I have two questions regarding report creation: 1. I have an attribute called email which holds two email IDs (a school and a personal ID) for a single user. I want to display only the school ID in the report and need help figuring out how to do so. I tried the filters option, but it limits me at 500 values, while my report has 4,000 rows. This is causing issues when I export it into a csv as two rows are created for the same user. 2. I have a column which is displaying values in quotation marks, as shown in the attached screenshot. When I export this report, the values are not getting exported properly, and I need help resolving this issue.
m
Hi Rujuta, 1. I believe it should be possible to create a standalone attribute for school and personal email via a SQL query, e.g.:
SELECT {Email} WHERE CONTAINS({Email}, "@school.edu")
For this you would need to create an SQL dataset: https://www.gooddata.com/docs/cloud/model-data/create-logical-data-model/create-sql-datasets/ Otherwise, you could need to create a new attribute or derived column in the dataset with only the school email.
2. Could you please provide an example how the values look like in the export?