In slices - can you write an expression on a ...

expressions
(Tammi Canelli) #1

In slices - can you write an expression on a virtual column?

(Jonas /) #2

Can you be more specific?

If you want to use a virtual column as a filter for a slice, the answer is:

Yes, you can do that.

(Tammi Canelli) #3

I have a table that’s my main table used year round.

During incidents, like a hurricane, there is additional data collected that results in certain actions.

Because this is incident specific I was trying to keep this data separate from the main table.

However, i run into issues with workflow because I can’t cross reference certain columns.

I found myself adding columns to the main table just to get filtered data the users could act on - pain.

(Jonas /) #4

so you got 2 tables and want to filter data in table A, based on data in table B?

as long as you use a column of the type “ref” that references the one table to the other you can access columns like this

[tableA_key].[tableB_column]

does this help?

(Tammi Canelli) #5

I would use in the slice filter?

Here is what I’m trying to do.

Assigned Caller is in table a (registry) but the outbound call complete is in table b (call out).

Preferably I didn’t even want the assigned caller in the registry table but I couldn’t figure out another way to get the names to display in the views I needed.

AND(ISNOTBLANK([Assigned Caller]), [Registry_RegID].[Call Out_Outbound Call Complete]=“no”)

Try to get all the completed calls to filter off the callers list.

(Jonas /) #6

So you just want to show the calls wich are not done?

Do you initially save “no” to [Call Out_Outbound Call Complete] ?

If that is the case, then this should work just fine.

Can you make your APP publice so that I can check out the column structure?

(Jonas /) #7

you could duplicate it first (to keep your private version to you)

(Tammi Canelli) #8

I don’t know how to do that.

Am I able to add you as a collaborator?