6 Replies Latest reply on Jul 21, 2017 9:19 AM by Natalia Alvarez

Discrete measure AFTER continuous measures in table

As the title says, I am now working on a table that has a couple of dimensions, a couple of continuous measures and a discrete measure. I need the discrete measure to be in the last column, but so far I haven't found a way to do it.

Due to the data that would go with it I cannot upload a packaged workbook, but if needed I can prepare some fake data and upload it later  I have attached a workbook with as close to the data as I could get.

The table looks like this:

I need "Slot A" and "Day A" to be the final columns because they are derived from Avg C and %Q. "Day A" is created through a level of detail calculation and I can' change it to be either a dimension or a continuous measure.

Any ideas? =)

Mensaje editado por: Natalia Alvarez  Attached workbook

• 1. Re: Discrete measure AFTER continuous measures in table

This can be done. Please attach a workbook.

• 2. Re: Discrete measure AFTER continuous measures in table

I have uploaded the workbook =), it is as close as I could get to the one I am working on

• 3. Re: Discrete measure AFTER continuous measures in table

Hi Natalia,

I can't understand the names. Can you explain which one you need in view and what order.

Thanks

Deepak

• 4. Re: Discrete measure AFTER continuous measures in table

Sorry, forgot the alias on the first post. I need the view to end up like this:

The fields that are shown are:

- # Deptos (Dimension)

- Csat(Measure, average)

- % quejas por depto (Measure, calculated field)

- Hora con peor CSAT (Measure, Minimum, calculated field)

- Day A (Discrete measure, calculated field)

• 5. Re: Discrete measure AFTER continuous measures in table

Like This:

• 6. Re: Discrete measure AFTER continuous measures in table

>< of course, turn them all discrete, I should have thought of that one

Thank you for your help and all the time you spent on this question =)