topic Re: Dimension based on another dimension in App Development

Dimension based on another dimension

alessandrotk — Fri, 15 Mar 2024 14:08:11 GMT

Hi,

I'm looking for a way to handle this at sheet level (not script or using variables) so that I can have a dimension called "Title" to be based on a sort of if statement from another dimension called "Name"

I don't want to write if [Title]='Customer Support Engineer' then 'Technical Support Engineer', but rather if [Name] is 'Mark' then the [Title] value should be used from 'Paul' instead ('Technical Support Engineer').

Load * Inline [

ID, Name, Age, Title

1, Wladimir, 31, Team Lead

2, Paul, 22, Technical Support Engineer

3, Mark, 40, Customer Support Engineer

4, Janne, 27, IT Specialist

];

Try to handle this at a table level if possible.

Thanks,

Re: Dimension based on another dimension

brunobertels — Fri, 15 Mar 2024 14:29:02 GMT

may be this

if(match(Title,'Customer Support Engineer'),'Technical Support Engineer',Title)

Re: Dimension based on another dimension

PhanThanhSon — Fri, 15 Mar 2024 14:38:12 GMT

Hi,

I know an easier way, you don't even have to open your script editor for this, but loading the data is necessary:

Go to "Edit Sheet".
Select "Left Fields".
Click on "ADD Data".
Choose "Manual entry".
Rename the first field to "Title".
Rename the second field to "Title Adjusted".
Write the mapping correctly.
Give a name to the table.
Click on "Next" (to load the data).

This will create a new table in the background without ever having been in the editor or having written an IF statement.

I would recommed you to work in the script directly but this solves your problem.

Best regards Son

Re: Dimension based on another dimension

MatheusC — Fri, 15 Mar 2024 15:09:48 GMT

Hi, @alessandrotk

Following the idea given by @brunobertels , if there are other titles like 'Customer Support Engineer' and you just want to change Mark's, you can also add and as follows:

if(match(Title,'Customer Support Engineer') and Name='Mark','Technical Support Engineer',Title)

Regarts, Matheus

Re: Dimension based on another dimension

alessandrotk — Fri, 15 Mar 2024 15:32:29 GMT

Hi,

I don't want it to be based on/hard coded to the [Title], but rather [Name] since that person could have a new Job Title in the future. I'd like to be always based on [Name] and display the [Title] value from that hard coded name instead.

logically I tried something like

if([Name]='Mark', aggr([Title], [Name]='Paul'), [Name])

but I can't have aggr in a dimension and it doesn't seem to work either.

Thanks