I have a table that has a row [Type] with the value of Gas or Water. Iโm trying to create a filtered view with a slice that contains the value. I have tried [Type]=Gas, [Type]=โGasโ neither filters out water. Please see below
Sorry if there is a thread about this. I could only find ones with numbers and dates.
Thanks for you help
Solved! Go to Solution.
I did tried to create a sample based on your initial information, to filter-out water from the list. Below is my configuration created yesterday. However, I am still learning also so I donโt understand why it was working.
It should be working, also with something like: IN("Gas", LIST([Type]))
Maybe the Table view is not yet pointing to the slice?
Your [Type] column in Logs table which you are trying to filter out is a REF column. So you need to construct your expression like:
[Type] = [Key_Column_Of_Referenced_Table]
Hello LeventK
Iโm not following you on this.
So this is what I have
Table - [Logs] (ID, Date, Type, Level)
Table - [Type] (Type)
So are you saying the expression should be
[Type] = [Type].โGasโ
Which table the [Type] column in your Logs table reference to and whatโs the key column of that referenced table? Can you give a screenshot both from the column structure and gSheet of that table?
There is only 1 column in the [Type] and it is called Type
I also took a screenshot of the output as well.
I thought I had the expression correct but I didnโt work.
Thanks for your help
Can you try with:
[Type] = [Type].[Type]
Same thing
The view youโre using to display the data must use the slice rather than the original table.
I was hoping that was what the problem was but Iโm already using the sliced view
Are you?
The Type column is of type Ref:
When a Ref-type column value is displayed, the label column value for the row referenced by the Ref column value is displayed instead of the Ref value itself.
It seems odd to me your Type column would be of the Ref type. Is that intentional?
@Steve
@Virgil_Wilson said that he has a TYPE table, with a column named Type as well, itโs a single column (both key & label) with merely 2 records: Gas and Water respectively.
Looks like Iโm confusing thingsโtoo many cooks in the kitchen! Iโll step out of your way.
@Steve mines are fried already bud Take careโฆ
The column is a ref because I donโt want hard code the value in the Enum. So it is a ref so it can get the different type of โTYPESโ
Actually you donโt need REF for that. You can construct a SELECT expression in the Valid_if and can keep the column type as ENUM or even TEXT:
SELECT(Type[Type],TRUE,TRUE)
OR merely
Type[Type]
I suggest change the column type from REF to ENUM (base text) and use one of the expressions in Valid_if. Also explicitly mark Allow other values to TRUE. Keep your slice expression as:
"Gas" = [Type]
Sorry for the question Iโm a newbie of 3 days.
I suggest change the column type from REF to ENUM (base text) and use one of the expressions in Valid_if . Also explicitly mark Allow other values to TRUE. Keep your slice expression as:
I did change the column type to ENUM on the table. Where is the Valid_IF and Allow other values TRUE at.
Expand your columnโs structure
It still doesnโt work but I did it another way. Thanks for your help
I have another question though if you donโt mind
I have a table [LevelAmount] and a column [Levels] with levels 0% - 100%
Google Sheet - LevelAmount
Table Structures
The problem I have is that value isnโt percent
Why is that?
Your column type is Text, consider changing it to Percent
I have tried that.
I did tried to create a sample based on your initial information, to filter-out water from the list. Below is my configuration created yesterday. However, I am still learning also so I donโt understand why it was working.
Thanks I will try that. I already found a work around to do it.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |