is there any way write something at place of 0,1,...
# gd-beginnersg
Gaurav Tiwari
03/27/2023, 7:40 AMis there any way write something at place of 0,1,2 complete ,Not Complete , Pending
j
Joseph Heun
03/27/2023, 8:02 AMYou can change the way attributes are displayed through the use of attribute labels. This allows you to use the numerical values or the strings for the “completed” and “Not completed” values.
g
Gaurav Tiwari
03/27/2023, 8:08 AMi didn't get it will you please explain it
j
Joseph Heun
03/27/2023, 8:32 AMI believe your screen shot indicates that you are speaking about the attribute filter “Status,” Correct?
Currently, the display label is displayed with data type integer. If you go to your LDM, you will have the option to set string values there. This may be a better article for you to start with as it shows how the labels and values are used within the LDM:
https://help.gooddata.com/doc/enterprise/en/data-integration/data-modeling-in-gooddat[…]el-components-in-gooddata/attributes-in-logical-data-models/
g
Gaurav Tiwari
03/27/2023, 8:54 AMyes but i want display string form without changing any thing in orignal data
j
Jakub Kopecky
03/27/2023, 9:18 AMHi Gaurav, pls read the article from Joe or read the part about attribute labels here: https://help.gooddata.com/doc/growth/en/data-integration/data-modeling-in-gooddata/lo[…]el-components-in-gooddata/attributes-in-logical-data-models/
j
Jan Soubusta
03/27/2023, 9:21 AMNot sure, if you use GoodData.CN/cloud or GoodData platform.
In the GoodData.CN/cloud we just released a new (beta) feature - SQL datasets.
If you do not want to change you data and achieve the above, you can create a SQL dataset and with a SQL query you can define a "virtual" column(attribute) derived from the numeric physical column.
j
Jakub Sterba
03/27/2023, 6:34 PMIn case 0, 1, 2 is result of metric, you can use conditional metric format
[=0]complete;[=1]not complete;[=2]pending;otherJakub Sterba
03/27/2023, 6:42 PMFor attributes I suggest to add dimension dataset which translates state IDs to text values. The text value can be either separate attribute or default display label for the same attribute where ID is used as primary label. Both ways will let you to keep ids in all other fact tables where state dimension dataset is going to be referenced. SQL dataset may help you do it without need to create such dimension table in the database physically.