This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Can Someone please assist... Im using the Summarize tool to Group 6 Colunms and Count 1. Issue I comming across is one of the colunms represent a Emply number.. example (a123456). When I run report if that number reflect 5 times in that colunm.. instead if in grouping as same number it changing data to a series of numbers example (a123456 then next is a123457 ,a123458,a123459,a123460. and does combine as one and count all with original number of a123456? Hope that makes sense.. Data is set to "String"
Hi @bigdaddyvette , as @Qiu said we are not facing any issues with the dataset you provided and produces the result as expected there might be some whitespace in the values that is treating as separate value. I request you to rather share the workflow you are working on so that we can debug the issues. Please refer to the screenshot.
Yes.. Thats was just an example of what Im getting on diff Data... Cant share the real data... but its whats taking place... which is very odd as Ive used this tool many of times... If i use the example I provided it works for me as well...