cancel
Showing results for 
Search instead for 
Did you mean: 

How do I export the view of my Filtergram?

Highlighted
Linear Actuator
I have a Filtergram on a Step in my Project and I'd like to export that view to an AnswerSet. How do I do this?
This is a common data prep scenario and you can capture that Filtergram view in four easy Steps.

In this example, here's a Filtergram view of the Season1 column:
Image: https://us.v-cdn.net/6030933/uploads/editor/u0/jmcvrszq9e7l.png

To capture the view above in an AnswerSet:

1. Perform a Group by on the column––in this example, the column named Season 1. And the resulting new aggregated column becomes the Count – Show Name column:
Image: https://us.v-cdn.net/6030933/uploads/editor/k3/dfzlmuphwdgy.png


2. Sort the new Count – Show Name column by descending:
Image: https://us.v-cdn.net/6030933/uploads/editor/7a/tbwl6da241ja.png


3. Now create a Lens for this view: Click the Lens tool, provide a Lens name, and Save the Lens to the Step:
Image: https://us.v-cdn.net/6030933/uploads/editor/ge/0pcqddtgrona.png

4. Publish the lens for export. Note that when you mouse over the lens icon on the Step, the Publish button displays:
Image: https://us.v-cdn.net/6030933/uploads/editor/r5/wli2fptezdv1.png
Labels (1)
0 Kudos
0 Replies