Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Is there an equivalent to “show values” in a field as opposed to summarizing the unique counts?

Answered
Kabir Rao asked on September 25, 2020

Hi, noob here to Flexmonster. I have a data source that has three “dimensions” (sort of like a fact table in data warehouse speak). Each of these dimensions can have a character value. So the table looks something like this:
Department          Risk Scale             Risk Type                 Value
ABC                     Inherent Risk        Strategic Risk            Minor
ABC                     Residual Risk         Financial Risk            High


I’d want my pivot table to be such that Department is present in the “Report Filters”, Risk Scale is in the “Rows” and Risk Type is in the “Columns”. However, I’d want the values to represent the actual values here, i.e. “Minor”, “High” and so on. It’s safe to assume that for any combination of the three dimensions there is always going to be 1 “Value” field. 
Is there a way to do that using Flexmonster? 
 
Thanks!

3 answers

Public
Milena Pechura Milena Pechura Flexmonster September 29, 2020

Hello, Kabir,
 
Thank you for writing to us.
 
Taking into account your case, we would like to suggest a workaround:
Please change the values of the “Value” field by switching from string to number type. For example, replace “Minor” with 1, “High” with 2. Then define the aggregation for the “Value” measure that will not change its value: for ex., “max”. Finally, use customizeCell API call to change numeric values to the corresponding string values.
 
We have prepared an example for illustration: http://jsfiddle.net/flexmonster/ogd497t6/.
 
Please let us know if it helps.
 
Best regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster October 9, 2020

Hi, Kabir,
 
We were wondering if our response helped you with your question.
Could you please let us know whether the provided example works for your case?
 
We would be happy to hear your feedback.
 
Best regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster 5 days ago

Hello, Kabir,
 
We are just checking in to ask if you have found our response helpful.
Did you have a chance to check the suggested workaround?
 
Looking forward to hearing from you.
 
Kind regards,
Milena

Please login or Register to Submit Answer