Formula to table?

[alexis]

Hi

The below represents the formula that I use to calculate a KPI.

As you can see the formula consists of a number of elements that refer to a number of dimensions (like "Software Owner", "ModelID") as well as "filters" such as "Vendor Name", TFDescription" etc.

I get the correct result (the number of Terminal_ID that meet the criteria that I specify) but now I need to create a table of the "qualifying" terminals and their dimensions - any idea how I can use this formula to create the results table?

Your help would be highly appreciated

= count (

{$<

[$(=Concat({1<$Field-={'VendorName','ModelName','TFDescription','SerialNumber','TID','MerchantID'}>}distinct $Field,']=,[')&']='),

[Terminal_ID] = E({1<[stat_type] = {'1','2','3'}>}),

[SoftwareOwner] = {'999'},

[ModelID]= -{'25','26','27'},

[ProdOUTNumeric] = {'>=$(=Min(DateNo))'},

[ProdINNumeric] = {'<=$(=Max(DateNo))'}

>} DISTINCT [Terminal_ID])

[Clever_Anjos · Accepted solution]

1. create a graph simple table
2. Add Terminal_ID as dimension
3. Add other dimensions
4. Add that formula as first expression
5. Hide the last column if you want (Presentation Tab)

[alexis]

Excellent - your solution is exactly what I was after.

Thank you Clever Anjos!