Hey!
We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

How to display a (static) measure once

Answered

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”?

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

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

Please login or Register to Submit Answer