How to get individual Inline Views for custom REF_ROWS() columns?

Is this a bug?

I have a Goal on which I list 3 Tracking types - Completion Rate, Time Spent and Satisfaction Score. Each day 3 new Tracking rows with their daily values are inserted for this Goal.

Currently, there is a Goal Tracking table for entered daily Tracking type rows and the Goal Detail View is showing an Inline Table with all of the Goal Tracking entries - (in this example 21 rows - 3 row over 7 days)

In the Goal record, I ALSO want to be able to show an individual chart for each of these Tracking items.

In attempts to accomplish this, I created 3 Slices filtering ALL Goal Tracking rows by the Tracking Types. I then added 3 Virtual Columns to further filter these slices into lists for that Goal. The expression in these VCโ€™s are similar to:

REF_ROWS("Completion Trackings", "Goal")

When I view each of the Slices data, they are shown properly filtered.

When I display the Virtual Column lists in the Goal Detail view, the counts in the inline tables reflect the correct expected number of rows - 7 rows per Tracking Type.

HOWEVER, the actual list displayed in these custom lists is all of the rows for that GOAL - i.e. the same 21 rows in the original Inline table - AND the View used is based on the base Goal Tracking Table not the Slices.

Inline View for Completion Rate Tracking rows

Tapping View Button - Original view and table - not based on Slice as the datasource?

  • Am I doing something wrong for my custom Virtual columns?

  • How do I get them to use System Inline Views or my own Views based on the Slices?

Solved Solved
0 6 306
1 ACCEPTED SOLUTION

How do you have this field set for your new REF_ROWS VC?

3X_4_c_4cdff75ef11f1a0b06e76cabea85ae0cfbaf17d7.png

View solution in original post

6 REPLIES 6
Top Labels in this Space