Need to create common headers for subheaders

Question & Answer
, ,
1

I need to create two common headers for multiple subheaders. For example I have 4 multiple category and subcategory subheaders and on top of it I would like to mention category-validation and similarly for Accuracy as common header for sub headers like category accuracy and subcategory category accuracy.

I tried to create that with text box, but in table viz, there are more than 10 columns are available. so if I scroll the table in the viz to the left or right, actual columns are moving but text box are not moving as it is disconnected with actual columns. Hence this approach is not suitable to implement.

Is there any alternative solution to create common headers for multiple subheaders. Could someone provide your insights on that?

Thanks,
Raja

1 Like
2

Hello @Raja, you could use a calculated field to create different headers and subheaders and add them directly into the field well to display in the pivot table. You could use an ifelse statement, check for the values you would want the columns to be grouped by, and return the naming convention you are expecting.

ifelse(
{your field} = 'accuracy'. 'category accuracy',
'category validation'
)

This is a fairly simplistic example, but it should help guide you in the right direction. Please let me know if you have any questions.

3

Hi @DylanM

Thanks for helping me to sort out my requirement.

I understand if else calculation, however I could not understand how this will create common headers.
Here in my example is
Category, Subcategory, Product is the actual column and the common header I have to give them here as ‘Validation’ and other set of actual column is
Category%, Subcategory%, Product%, hence the common header should be ‘Accuracy%’
I am not sure, how can I bring this columns within this calculation to make it work.

I have attached image for the reference

common headers
common headers804×205 6.33 KB

1 Like
4

Hello @Raja, if you create a calculated field like I made above with the correct naming conventions and add it to your columns field well, you could then create another calculated field that would return the values are are expected within each grouping/subgrouping.

Category or Category% = ifelse({header} = 'Validation', {Category}, {header} = 'Accuracy%', {Category%}, NULL)

The only issue you would face here is that your Category and Category% values are not the same value type. One is a percent and the other is a integer. There wouldn’t be a way for you to display them differently. Maybe if you apply the format settings on the 2 base fields it would work, but I imagine it will force both into the same format.

5

Thanks @DylanM , I will try this calculation and come back with the result

1 Like
6

Hello @Raja, did my above calculation help resolve the issue you are facing? If so please mark it as the solution or let me know what other problems you have run into and I can guide you further.

If we do not hear back from you in 3 days, I will archive this topic. Thank you!