-
Pivot Table App In the App Store
Sometimes you just need a Pivot Table. At RXA, we often find ourselves trying to create very specific tables and it can be challenging to get the rows and columns just right, and sometimes it can be nearly impossible. So our team created a simple Pivot Table app to solve this problem, and it's live in the Appstore this…
-
Table Subtotal Sorting
On the table card, once you've enabled "Show Subtotal Rows", has anyone else encountered issues with it forcing the first row to be the primary field? I've got a few cards where the first row is a formatted date (or some other non-numeric value) that looks like "January 2018" for several months. I love the ability to be…
-
Create a MagicETL function to Split Column and Dynamic Unpivot
I have a column that contains multiple values. I would like to be able to flatten these values. Ex: Document ID Author(s) 12 Bob^Sally 13 Bob 14 Fred^Ann^Sally I would want the output to be: Document ID Author(s) 12 Bob 12 Sally 13 Bob 14 Fred 14 Ann 15 Sally
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this…
-
Ability to wrap text on header row of mega tables
Would love to see the ability to wrap text on the header row of a mega table. Anyone else?
-
Mega Table Subtotals: Need more flexibility
On Mega Tables, you can only subtotal by the left-most column. However, sometimes there are sub-categories within that larger parent category that also need to be subtotaled. Please add the ability to subtotal by further depth. In the image below, I want to be able to sort the whole table by my first column, closing date,…
-
Table Date Range Field Drop Down
The table Date Range option should not be fixed on the first Date field in the table. The drop down should be functional regardless of the fields in the table. Currently, the first date field is used for the date grain. This limits functionality and flexibility in reporting. You can only select the date range field when no…
-
Table Card Interactions on Story Dashboard
Does anyone know if it's possible for 2 table cards on a Story Dashboard to highlight similar content on the other card when one card is hovered over? I'm trying to easily see the same information on 2 table cards when they are not in the same order because one card is filtering with the page and the other is not…
-
Total/Subtotal options for dates
When building a table, it'd be good to have the option to subtotal date fields by something other than COUNT. Basic options like MIN or MAX, would help answering key business questions like when the last interaction took place, or when we first interacted, while still displaying in the table the full list of interactions…