Unable to see the stacked by fields in report

[Nisha Kumari2]

Hello, 

I am importing excel file in Report to create one report. I have selected bar chart type for report. In configuration, Group by field is showing all the fields which are present in excel file but in Stack by field it is not showing any excel file fields.

You can refer the attachments for the information. 

Thanks,

Nisha

[AndersBGS]

Hi @Nisha Kumari2 ,

Which table have you dropped the Excel file in? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Nisha Kumari2]

Hi @AndersBGS ,

I have used Source Type as External import and not table. You can check the image.

Thanks.

[AndersBGS]

Hi @Nisha Kumari2 ,

I actually think that this is a product limitation by ServiceNow. I checked within my own PDI where I got the same result. Also located this question from 2022 (same question as yours) but without an answer: 

https://www.servicenow.com/community/platform-analytics-forum/bar-chart-stack-by-doesn-t-work-on-ext...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Nisha Kumari2]

Hello @AndersBGS ,

Thank you for your response.