Hi!
We have a โProjectโ table that has REF to โCalculationsโ table, that โCalculationsโ table REF to โItemsโ
The data inside Calculations of course can contain more than once the same โItemsโ
Basically we wanโt a view (Interactive Dashboard) that will output the Calculations Items based on a project but just show UNIQUE values.
Ho can I do this?
Thank you so much for your help!
The SELECT() function has a 3rd optional parameter to omit duplicates. Write a SELECT() expression to return your desired list of Items and then set the third parameter to โtrueโ.
Thank you so much for this quick reply.
Iโll give a try!
Thanks again for helping me, Unfortunately, I canโt find a way to make an โYes/No expressionโ inside the SELECT() function because those rows will be filtered in a dashboard โInteractive modeโ.
Do you have any ideas on how to do that?
I am not sure what you mean by this.
Letโs back up a bit. I assume your intention is to select a โProjectโ in one view and then through an interactive dashboard display in a second view a distinct list of โItemsโ from your โItemsโ table that belong to that project. Do I have that correct?
To do this, two things need to happen:
1). You need to have the Project Key column represented on your โItemsโ table so the proper filtering can take place. I believe you can add this as a Virtual Column.
2). You will need to provide a list of โItemsโ to the โItemsโ view that are already reduced to distinct items by Project. Probably the easiest way to do this is to create a Slice to reduce the rowsโฆalthough a solution is not coming to mind right away. Iโm sure thereโs a way to do it.
Slice condition can be something like:
[_THISROW] = INDEX( FILTER( thisTable , [column] = [_THISROW].[column] ) , 1 )
Use ORDERBY as well if needed.
This saved me thank you!
Thank you so much for your help!
Iโll give a try!!
Years later this saved me! Thank you so much!
For anyone else that happens across this post, you might find something in the following video to help with setting all this up:
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |