Creating a summary table from a straight table

[sayadutt]

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

[Vegar · Accepted solution]

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, ', ')

[sayadutt]

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.

[sunny_talwar]

May be this

[sunny_talwar]

You can try this

Concat(DISTINCT {<Issues = {"=Len(Trim(Issues)) > 0"}>} Issues, ', ')

[Vegar]

I believe that @sunny_talwar suggested adjustment should work.

[sayadutt]

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))

[sayadutt]

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))

[sunny_talwar · Accepted solution]

May be this

Count({<Available = {'Yes'}>} project)

[sayadutt]

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.