Hiya, first time poster!
I have a widget/dashboard that imports a list that I designed to help me identify buyers who might be buying multiple performance dates of a production in order to resell them at a higher price (against our policies). Here's a snippet:
Sorry this is hard to see. But basically, we want to filter this table so that it only displays constituent IDs that have a Performance ID count greater than their Production ID count. (so only the last 2 rows in the above table would be displayed.)
How do I accomplish this?
Thanks! Lori
Tessitura Application Support Specialist /TDF
Hi Lori,
A formula that has
COUNT( [Performance ID] ) - COUNT( [Production ID] )
would be 0 when equal and greater than 0 when not. Then filter the value to limit results to those greater than 0.
Adding a Widget Filter (tessituranetwork.com)
To filter the values of a field that already exists in the Data Panel of the widget, you can click the filter icon on the field (which appears when the pointer is over the field). The filter window opens straight to the filter settings. After you complete the settings the filter is added to the Filter tab.
To filter the values of a field that already exists in the Data Panel of the widget, you can click the filter icon on the field (which appears when the pointer is over the field).
The filter window opens straight to the filter settings. After you complete the settings the filter is added to the Filter tab.