Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table and looking for a summary table as shown below:
Now I am looking for a summary table which will group the projects and show the all the issues comma separated.
Also, status column should be based on :
Complete - once ALL the individual status for that project move to "complete".
In progress - when ANY of the individual status for that project is still under to "in progress".
Not Started - when All status are Not started
Try to create a straight table with the field Project as a dimension and the following two expressions.
Status:
If (IsNull(Only(Status)), 'In progress', only(Status))
Issues:
Concat(Distinct Issues, ', ')
Try to create a straight table with the field Project as a dimension and the following two expressions.
Status:
If (IsNull(Only(Status)), 'In progress', only(Status))
Issues:
Concat(Distinct Issues, ', ')
Hi Vegar,
Thanks for your reply.
For:
Issues:
Concat(Distinct Issues, ', ')
only commas comes when there are blank values under Status. Can you please guide how I can hide the commas when Status is blank.
May be this
You can try this
Concat(DISTINCT {<Issues = {"=Len(Trim(Issues)) > 0"}>} Issues, ', ')
I believe that @sunny_talwar suggested adjustment should work.
Thanks it worked.
Can you help me with another column.
In same table I have another column as :
Available
yes
no
I want to put the count of yes only in the summary table like
Count of Available
have tried below as expression: no results were returned:
if(Available='Yes', count(project))
Thanks it worked.
Can you help me with another column.
In same table I have another column as :
Available
yes
no
I want to put the count of yes only in the summary table like
Count of Available
have tried below as expression: no results were returned:
if(Available='Yes', count(project))
May be this
Count({<Available = {'Yes'}>} project)
Wonderful Sunny.
last question: similar column I need to add on a date field.
Need is to display the largest date from the table.
7/30/19
7/31/19
7/29/19
In this case, only 7/31 should be displayed as thats the greatest from the list.