Calculated dimension

Mark4 — Sat, 16 Nov 2024 04:21:10 GMT

I have a field aliasing a binary value: [Is Current] = 1 for True, =0 for False in the data load editor

I made this a dimension column in a table aliasing the 1 and 0 as "true" and "false", respectively.

eg:

if([Is Current] = 1, 'True', 'False') - Too easy

But when you select on either option within the table, the filter box at the top of the sheet displays the formula. I need this to display 'Current or Historical'. I also need to do this without adjusting the script in the data load editor, so all of the code needs to be in the app.

Any ideas?

Thank you in advance

Re: Calculated dimension

StarinieriG — Fri, 18 Oct 2019 09:02:57 GMT

Hi,

have you tried to create a master dimension and then use it?

Re: Calculated dimension

Mark4 — Tue, 29 Oct 2019 13:46:08 GMT

That did it, thank you!

topic Re: Calculated dimension in App Development

Calculated dimension

Re: Calculated dimension

Re: Calculated dimension