topic Re: How to make a 'measure' from a dimension in App Development

How to make a 'measure' from a dimension

Agora — Wed, 02 Aug 2023 15:26:44 GMT

Hi,

I have a dimension 'invoice number'.

In order to control if data is fully loaded i want to compare

- count of invoice numbers

with

- (max)invoicenumber - (min)invoicenumber --> but i don't know how to create this as a master measure from the dimension invoicenumber.

Ideas?

Re: How to make a 'measure' from a dimension

cristianj23a — Thu, 03 Aug 2023 01:32:49 GMT

Hi, is this code useful?

LOAD *,
Count(InvoiceNumber) as CountOfInvoiceNumbers,
Max(InvoiceNumber) - Min(InvoiceNumber) as DifferenceMaxMinInvoice
Resident YourTable;

If it is not what you want, you can give me more detail with some examples.

Re: How to make a 'measure' from a dimension

mjht — Thu, 03 Aug 2023 14:28:58 GMT

I am just wondering why you need it to be a master measure?

Also - is there a possibility that you could have duplicate invoice numbers ? Perhaps an invoice comes thru with a correction. In that case simply taking the max(invoice number) - min(invoice number) would not necessarily give you the correct answer.

Re: How to make a 'measure' from a dimension

cristianj23a — Thu, 03 Aug 2023 14:45:39 GMT

I couldn't give you the answer because I don't know how your tables are structured, your queries are very general, if you give me more detail with examples I could help you.

Re: How to make a 'measure' from a dimension

mjht — Wed, 09 Aug 2023 17:44:44 GMT

@cristianj23a - my response was to @Agora . I think you really wanted to address your response to @Agora and not me.