Skip to end of banner
Go to start of banner

Combining Object Swapping with Category Objects

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Our article on Object Swapping explains how you can create an object that you can use to change the values on an X (or Y) Axis. In this example we take it one step further and use objects to change the Legend and X and Y Axis combined with an object that filters the data in the chart.

Instructions

If you want to create this in your own dashboard, follow the instructions below and substitute the objects with the information you want to view:

  1. In Dashboard Configuration>Data Connections, create the following objects in the Dashboard Repos connection:

    For each object we’re using the COLS.DISPLAY_NAME object and in the WHERE clause, we’ve specified the columns that we want to be available for users to swap between. In the Legend example, we’ve used the values Payment Method, Fraud and Sales Year which all come from our Retail data connection.

  2. In the Retail data connection we then created the following objects, this is an example of the Legend object:

    We called this object ‘Swap Legend’ but you can call it whatever you want. The ‘Select’ statement for this object refers back to the object that we created in Dashboard Repos called ‘Legend’.

  3. In Dashboard Configuration>Categories add the objects that you created in Dashboard Repos:

    The ticks for ‘Can Select All’ and ‘Filter’ have been removed for all the objects that we want to use in Object Swapping. The only object that users can filter on is the ‘Store Name’

  4. We then build a chart that contains the objects we created in our Retail data connection:

  5. When users select an object in Category Objects, in the following example we’ve chosen an item from the Legend, they will see the columns that you entered in the WHERE clause in Dashboard Repos:

  6. After clicking the ‘Apply’ button, the Legend will swap to show the new selection and the chart will be updated:

  7. As a final step, to make the Axis and Legend label more meaningful to users, we used Object Replacement in the label fields on the Attributes screen:

You might also find these articles useful.

Filter by label

There are no items with the selected labels at this time.

  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.