Just curious - would you advise users to generally avoid using summary items in their details matrix, period? As in, no Sum of Month & Sum of Years in timelines, etc.,? It seems like a waste of a core...
Rich, regarding avoiding summary items - is it for the reasons you & I have discussed before, their usability problems when combined with e.g. valueat() and timeline? Or are there other reasons you...
I would like to add that "Item Names" has its use; however the current implementation is very flawed, in that the generated items loses all grouping structure. I would propose that the Generate Items feature...
Sau, The image of your sample code - how are you getting Quantrix to display the formulas in this way (with dark background)? It's very nice on the eyes!
You have my vote, Sau. Although syntactically I think putting the variable definitions near the front of the formula (after any "In ... " statement, but before the item name whose value is being set)...
If I understand Tahir correctly, he believes it would be easier to maintain a model where a single one matrix presents differently (w/ rows & columns filtered depending on user role) versus creating...
If I understand correctly, Tahir may have in one matrix (or table view) some sensitive information that should only be shown depending on user role. He desires to use a filter expression that filters rows...
Would it be possible to set properties such as width, height, hidden etc. for elements of a Canvas? It doesn't seem like the object model allows any access. What I would like to do is add some Actions...
Thank you Mike. The extra explanation helps!
Is this what you want? A single formula will do it.
What does this error mean? "Category XXXX references a field that is not compatible with the data source defined in matrix YYYYY " I have an XML data source containing multiple objects such as Employees,...
I manually edited the name of a item that was brought over from an XML Data Source via DataNAV, and also changed a value that was brought over via DataNAV. If I right-click on the Category tile and choose...
I'd like to be able to better differentiate between items in a category populated by DataNAV vs ones I manually add/modify, including Summary items. I don't see any way of "locking down" a DataNAV category...
FYI if you have the need to do different offsets simultaneously, I would suggest calculating a single index value (that ignores all summary items). That way can support multiple, differently offset data...
I am in fact already using Item Generation extensively! I end up having an input matrix with category DepartmentsInput and DepartmentsInfo, use Generate Items to populate items for a second Category Departments...
I'd like to keep the Item Names of Category A synced to match the value of a particular Item from Category B. I tried making converting Category A into a Primary Key and I can make it work once, but any...
You can't. You've already grouped A into 2, and B into 1. If you want to group A and B you'd have to remove groups 2 & 1 first.
I think your question about doing Excel-like sensitivity analysis may be addressed by the new Solver feature... I wouldn't know as I haven't used it yet. However, if you set up your scenarios such that...
Oh, and converting and maintaining the Excel file as a CSV is not an option. I would like the Excel file to preserve formatting, multiple sheets, etc.
