How to write expression in table.

[#1]

Hi,

I have Team as dimension and I need to show the Count of IDs which are in within DUEDATE and which are above DUEDATE.

Can anyone help me with expression please?

Thanks.

[#2]

Thanks for your help. The figures are showing values that are without blanks from DueDate. i,e the Total Open is 6006 intsead of 4566. I need to show the values including DueDate with Blanks. Could you please let me know how can I those and also I have to show

Closedwithinduedate+Breachedduedate should equal to count of Closed and the closed also I need to show DueDate with Blanks

Thanks in advance.

[#3]

Hey Amelia,

For the version you attached to me, it shows Open count at 5041. May be if QVD's will be refreshed with latest data then you can get the nunmbers matched with database.

For now, please see the attachment.

Let me know, if any other issues

--Angad

[#4]

Thanks very much! I mean it. Really great work.

Could you please let me know as I have one issue to get sum of values in one straight table.

I have to show SUM(AssetValue) where AssetValue<>'To Be Confirmed','N/A','Unknown'

Please could  you tell me how can I do this. I did to show the count(Assetvalue) but now I have to show the SUM(AssetValue) as another column.

[#5]

Can you try using:

sum(distinct AssetValue)

Or can you create a new thread, so that new members can also help in this.