cannot graph virtual columns in slice... options?

Event data stored in sheets data source.  Future events have been enrolled, but have yet to complete and have a zero score.  Virtual columns used for calcs to compute score; used in a view with a stacked graph. Future events show up on graph as zero score.

To remove them from the graph, created a slice with a filter of: "score > 0".  Works when looking at slice results; they are indeed gone.   Changed view to use slice and found out you cannot have VC in slices.

Appears doing this with a slice isn't workable... What options exist to prevent enrollments with a zero score from being graphed along with fully completed events?

Solved Solved
0 2 116
1 ACCEPTED SOLUTION


@jeffminder wrote:

Changed view to use slice and found out you cannot have VC in slices.


This is not correct.  Why do you think so?

Screenshot 2023-10-31 at 1.18.39 PM.png

Screenshot 2023-10-31 at 1.21.55 PM.png

View solution in original post

2 REPLIES 2


@jeffminder wrote:

Changed view to use slice and found out you cannot have VC in slices.


This is not correct.  Why do you think so?

Screenshot 2023-10-31 at 1.18.39 PM.png

Screenshot 2023-10-31 at 1.21.55 PM.png

Happy to admit was completely wrong here...  not sure what happened.   VCs were added to slice yesterday but it wouldn't let me add them to the graph for some reason.   Just tried again and it worked without issue...  weird, but glad it's working.  Thank you!

Top Labels in this Space