Forum Discussion
Analyze Data - Help with Structuring Data to Improve Analysis
Thanks for your answer, MarGines. I also have the data formatted as a table, but still couldn't get the answers I wanted out of the analyze data tool. This table has something like 15,000 lines of data, so I'm not exactly sure how I'd combine each year into one column. How does that work?
MicrosoftSorry that didn't work. I wasn't suggesting you changed the structure of your data, just that the scenarios for which we have optimized the feature so far typically have dates grouped in columns. We continue to iterate and improve the quality of the feature and we'll incorporate your feedback as we do so.
Thanks again for reaching out, skeskali
Mar
MarGines My data is structured in a regular table in another worksheet (see screenshot). This is not a pivot table. I guess what I was looking for was suggestions or specific syntax that would help me get the answers I needed from such a large data set. My brain thinks in natural language, not Excel, so I think that asking a table like this one "Show me the top istat for each location for each year" should work, but it doesn't. Is there somewhere I might learn more about the proper syntax structure and how I might get more out of this tool?
- MarGines
skeskali We currently don't have documentation of the sort you describe. Based on the structure of the data, we aren't able to understand "for each year". I think that asking: "top istat based on year 2017 for each location" would give you what you want, but you'd need to ask the same question for each year.
We'll explore how to improve this scenario.
Best,
Mar