User Profile
Elipum
Brass Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Weird. Duplicated values highlighted in Excel, but they are clearly not duplicates!
In excel, I am getting warning of duplicated values from this list. This prevents me from creating a data model relationship one to many. However, the values are not duplicated at all: 2.05.120 2.05.180 2.05.240 2.07 2.08 2.08.120 2.09 2.10 Isn’t it weird? Have you experienced something like this previously, and if so, is there a known solution for it? Thanks!Default custom columns when creating new site
Hi, I would like to set a custom column as default, so that when a new site is created, it will appear visible automatically. This custom column contains a link to a flow and it is a site column (it is a column formated with JSON to add the link). Is this possible? I find it very strange that no one has asked this before, or that this is not an option! Any help will be appreciated. Thanks!Pivot table from Data Model shows entries duplicated for all labels
Hi all, When creating a pivot table from the Sata Model, I am having the issue of getting a Pivot Table with repeated labels, that do not belong to the specific headings. (It repeats under each top label the same subcategories aóf all top labels, not the ones that actually belong to each of them). In my case, it is not possible to create a RELATED column in the data model in one of the tables, because entities are linked by date, and a more complex network of relationships. Additionally, the links are created between all tables using auxiliary tables with unique entities, therefore, the output should be showing that filter alredy, but does not seem to recognise those relationships. This is the relationships diagram (probably overcomplicated and with repeated info, because I have been trying all sort of options): Below, the relationship list: This are the fields I am using to generate the Pivot Table from the Data Model (The yellow message of "relationships are needed" pops in when adding to the pivot table the category that repeats in all labels. However, that relationship is already created!!): And this is the pivot table I get as a result, where lots of entries appear as blank in a category where they don't even exist (all labels in that column appear repeted inside every single level from the previous category): Anybody has had a similar case, and have found a solution or a way around already? Help is much appreciated! Thanks,
