Hey AppNation!
Quick question for youโฆI am trying to base a view on a slice and have line item columns with each of them being based on a slice.
What this looks like is a Billing slice made into a view that has virtual columns for the following slices within the slice:
Right now it is working, but when I go into the app itself it is bringing up each load (row) that has been input into the app. I really only want one load to show up at a time.
Is there a way to create an expression like:
Name of Slice[key column], but View[certain row]? to only fetch one row instead of a list of rows (loads)?
In the slice, include an equality for the Key column, like:
[Key Column] = โSomethingโ
Ok, like enter it as an App formula?
In the formula for the slice.
Ok, Thank you. When you say to make it an equality, do you mean something like:
[Key]=show()
You said you wanted to show only one rowโฆ how will you pick out that one row?
Do you have a specific key or ID of the record, so you can use that in your equality?
Yes, the key is [Key], sorry my brain feels like mush right nowโฆlong day.
I feel like the best course would be [Key]=Load Number might work?
That would pull out that one specific row, yes.
Thank you. I will give it a shot.
Ok, I tried
D Load Information[key]&
[key]=[load number]
in an App type virtual column.
It produced the following error:
From your original post.
The formula weโve been discussing would be for the slice expression: [Key] = โsomethingโ
Ok, so if I am hearing you correctly, you are saying that if I make [key]=โsomethingโ then that will input a singular column designated by whatever โsomethingโ is?
I dontโ know what you mean by:
This is the formula for a sliceโฆ the thing that says, โThis is the criteria for the rows that I want in this sliceโ
So thereโs nothing about columns here, itโs a filter for your records.
Ohhhh, ok. That makes things clearer.
Thank you.
Still on the lookout for a solution.
I was also thinking Broker Information[key].select(_thisrow)
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |