@Eric_Schwartz
1.) You can create a Chart type view with REF mode and use it as an inline view for each users Detail View
2.) You can create an action, display it as inline and append it to one of your columns table with a deep link of LINKTOFILTEREDVIEW(โฆ)
Thanks Levant.
Can you refer me to a working example of LINKTOFILTEREDVIEW()?
The Factory Inspections demo appears to accomplish what I was looking for, however I was unable to identify where data filtering by team is accomplished, or if it was actually updating the chart in this Dashboard?
best,
EricS
@Eric_Schwartz
I donโt have a public sample to show right at the moment. In fact I can create a working demo in my public sample app but as I will be going to a business trip early in the morning, I donโt have time to do it honestly. But I can say that the filtering of the records for the base table, occurs inside the LINKTOFILTEREDVIEW(โฆ) expression.
LINKTOFILTEREDVIEW("Some Table View", [Date Column] = TODAY())
of course you can expand the filtering criteria at the end or construct complex one with the use of expression power. You can use any filtering expression that will evaluate to TRUE.
NP. Thanks for the help, and safe travels.
Best,
EricS
Hi @Eric_Schwartz Here are some more examples.
will navigate to the โOrder Viewโ and display Orders whose Order Status is โOpenโ. The second argument to LINKTOFILTEREDVIEW is a filter expression over the rows in the view. This is similar to the filter in SELECT expressions.
will navigate to the โCustomers Table Viewโ and display high-priority Customers associated with the current sales rep.
will navigate to the โStudents Table Viewโ and display Students having ages younger than the current student.
Have you tried creating a Slice of the response table with a filter condition like USEREMAIL() = [respondent email] ?
You can point a graph table to that slice and each user will only see their results.
You could also try an interactive dashboard if you incorporate a table of responders and have the survey reference back to the table of responders
A huge shout-out to Stefan, Lynn and Levant who each jumped in with suggestions. This is a wonderfully supportive community.
Thank-you!
User | Count |
---|---|
44 | |
34 | |
24 | |
23 | |
15 |