How to display a (static) measure once

posted on September 8th, 2020

Answered

pjdvmalan asked September 8, 2020

Hi,
Thanks for a fantastic product.
Given the following configuration:

"rows": [
    {
        "uniqueName": "Type",
        "sort": "desc"
    },
    {
        "uniqueName": "SubCategory"
    }
],
"columns": [
    {
        "uniqueName": "Month"
    },
    {
        "uniqueName": "Measures"
    }
],
"measures": [
    {
        "uniqueName": "Amount",
        "aggregation": "sum",
        "format": "02fecc33bec74ccd9c8a0835259938f0"
    },
    {
        "uniqueName": "Budget",
        "formula": "min('BudgetAmount') ",
        "caption": "Budget"
    }
],

How can I display “Budget” column, which is static and will be the same, only once; whilst “Amount” is categorized by “Month”?

Attachments:
Screenshot_20200908_224328.png

measure

2 answers

WebDataRocks Team ⋅ WebDataRocks ⋅ October 7, 2020

Hello,

Thank you for contacting us.

We would like to explain that all measures added to the slice will be aggregated and displayed based on intersections of fields added to columns and rows arrays. Therefore, it is not possible to change the behavior of a separate measure.

Our team suggests considering creating an additional instance of WebDataRocks to display the “Budget” measure with the desired configuration.

We hope it helps.
Please contact us in case other questions arise.

Regards,
Illia

WebDataRocks Team ⋅ WebDataRocks ⋅ October 7, 2020