🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Using string in Measure

Resolved
Jimmy asked on April 12, 2021

Is it possible to show the string in measure instead of the count of it?
Is it possible to show the datetime in measure?
/JIP

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 12, 2021

Hello, Jimmy,
 
Thank you for reaching out to us.
 
Please note that all the fields added to measures will be aggregated. A limited number of aggregations is available for the string data type. All these aggregations (including count) are based on the numeric representation of the field’s member. Otherwise, the actual content of the members would need to be aggregated in some way.
The datetime data type also has a limited list of aggregations for the same reason.
For example, it is not clear what would be the sum of two strings or two dates.
 
In order to display raw data, we suggest using the flat form supported by Flexmonster. It allows rendering raw records without any aggregations applied. Please see the JSFiddle we prepared for the demonstration: https://jsfiddle.net/flexmonster/osc1hjwL/.
 
We hope it works for you.
 
Kind regards,
Illia

Please login or Register to Submit Answer