topic Re: Creating a new dimension? in App Development

Creating a new dimension?

Daryn — Tue, 06 Sep 2022 08:23:58 GMT

Hi all,

Thanks for taking the time to read this and hopefully assist me.

I am looking to show (in a pit chart if possible) so was trying to create a dimension for the 'slice'.

We have an order number, with two date fields. In my load script I have set:

[Order],

[Order] = [Actual Order Finish Date] > [Basic finish date] AS [LATE],

[Order] = [Actual Order Finish Date] < [Basic finish date] AS [EARLY],

[Order] = [Actual Order Finish Date] = [Basic finish date] AS [ON TIME],

I can show these as individuals count values or such, but want to create a dimension that as mentioned can be used in a pie chart, that will just give 3 slices. If I use them as they are I end up with each Order as a slice.

I hope that makes some sense?

I just want three slices and to report as 'count' of quantity of orders within that range.

something like;

I have a bar chart, but really want to show this as a pie if possible.

Using a date dimension and three versions (one of each for early, late, on time by switching the > < 😃 of;

Count ({<Order = {"=[Actual Order Finish Date] > [Basic finish date]"}>}Order)

// Late

If I convert that to a pie chart I get;

Thanks in advance for your help, as always.

Regards Daryn

Re: Creating a new dimension?

Or — Tue, 06 Sep 2022 08:38:23 GMT

These seems like a really clunky approach. I'd suggest using, in script, something like:

if([Actual Order Finish Date] > [Basic finish date] ,'LATE',

if([Actual Order Finish Date] < [Basic finish date] ,'EARLY',

if([Actual Order Finish Date] = [Basic finish date] , 'ON TIME'))) as [Order Finish Status]

You would then use this as your chart dimension.

If for some reason that approach is not feasible, you could try using a calculated dimension:

Coalesce([LATE],[EARLY],[ON TIME])

Re: Creating a new dimension?

Daryn — Tue, 06 Sep 2022 08:47:00 GMT

And this is why you are a Champion 👍

Thanks Or, superb help as always and very much appreciated. /bow.

Daryn