Manipulating the counting in filter boxes
-
Hi there,
My iok file contains a table based on buying orders by customers. A customers has multiple orders, so multiple records on the table.
My view shows the unique value count of the customer in stead of the orders, while the filter boxes show the number of table records.
Can I manipulate the counting in the filterboxes; so make it unique value count on customer in stead of record count?
Thanks, Arjan -
1 Comment
-
The filters only operate on the underlying data, so you would need to aggregate your data in a view such as the Table, export the aggregated view data as an IOK file (see Table view's View Tools menu), and open *that*.
Alternatively you may be able to write a formula which, for each record, shows the unique value count for that record's customer, something like:
SUBSET_UNIQUECOUNT( SUBSET( [Customer] ) )
Use the filter for this formula field.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.