Jump to content

How to get meta data of Categorial axis in Spotfire Mods

Holger Schimanski

Recommended Posts

For the categorical axis in Spotfire Mods I would like to know the Data fieldsit consist of.

For a row I can retrieve the values of the categorical axis e.g. US >> B2B >> Car.

I would like to know the data fields it is build from e.g. Country, Sales Type, Product.

And also all a list of all possible values of this data field e.g. US, UK, DE, FI in their natural resp. default order.

I don't know how to get such information from DataView or other Mods API.

Link to comment
Share on other sites

You can get the hierarchy information on the dataView using:

dataView.categoricalAxis("name").hierarchy.levelsNote that since there can be any kind of transformation on a DataView's categorical axis through the expression, there is no clear connection between a column placed on an axis selector and the resulting categorical axis in the dataView.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...