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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ October 1, 2024
Thanks Solomiia. Will try and confirm
