Drill Through in calculated measures

posted on September 23rd, 2024

Re-Open

Vaibhav Thirani asked on September 23, 2024

Hi,

I have created several calculated measures for my report. The count in the report shows correctly, however when I double-click and drill-through, the output shows all the rows instead of the ones that qualify for that calculation.

Is there a parameter that I am missing ?

Regards,

Vaibhav

6 answers

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ September 23, 2024

Hello, Vaibhav!

Thank you for reaching out to us.

Kindly note that in the described case, the drill-through view displays all rows of data that were used in the calculated values formula. For example, if you have a condition in your formula, drill-through will display all members that were checked for that condition, not only ones that fit.

Hope it helps.
Feel free to reach out to us if any other questions arise.

Kind regards,
Solomiia

Public

Vaibhav Thirani ⋅ September 23, 2024

Hi Solomila,

Thanks for the clarification. However, the usecase that I have needs the drill-through to show only the qualified rows of data. How do I achieve that ?

Regards,

Vaibhav

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ September 25, 2024

Hello, Vaibhav!

Thank you for getting back to us.

Kindly note that you can use filters to filter out the unnecessary members. Then, they won't be used in the Calculated Values formula and won't be shown in the drill-through (details) popup.

You are welcome to check out our documentation about filtering in Flexmonster: https://www.flexmonster.com/doc/overview-filtering/.

Hope it helps.

Kind regards,
Solomiia

Public

Vaibhav Thirani ⋅ September 26, 2024

Hi Solomiia,

Thanks for your suggestion.

Just for my understanding, when I do this in excel pivot it only shows the qualifying members. Is achieving this an impossibility without work-arounds and hacks ?

I think its the more intuitive approach since the calculation has already been done by the pivot. Or atleast I should be able to apply a qualifying function before the display of data in the popped window.

Regards,
Vaibhav

Public

Solomiia Andrusiv ⋅ Flexmonster ⋅ September 30, 2024

Hello, Vaibhav!

Thank you for getting back to us.

We agree that the described feature of showing in the drill-through view only records that fit the calculated value formula with the condition would be useful. Currently, Flexmonster shows all the records that are used in the formula.

As a possible workaround, we suggest moving the condition from the formula to the Report Filters. For example from this:

slice: {
   measures: [{
      uniqueName: "fieldName",
      formula: "if(min('fieldName') = 100, sum('fieldName'), 0)"
   }]
}

To this:

slice: {
      reportFilters: [
        {
          uniqueName: "fieldName",
          filter: {
            members: ["100"],
          },
        },
      ],
      measures: [
        {
          uniqueName: "fieldName",
          formula: "sum('fieldName')"
        },
      ],
    },

Hope it helps.

Kind regards,
Solomiia

Public

Vaibhav Thirani ⋅ October 1, 2024

Thanks Solomiia. Will try and confirm

Drill Through in calculated measures

6 answers

Please login or Register to Submit Answer