Jump to main content
Let's start off by building a query using 1010data's Trillion-Row Spreadsheet interface.
Using the 1010data Excel Add-in, we can run a query on 1010data from Excel and have the results directly downloaded into an Excel worksheet.
Our original query had date values hard-coded for the row selection. Let's add a little more flexibility by allowing the user to enter a date range using static inputs.
Let's set a result destination for our query results on the dashboard next to our input values.
You can apply basic and conditional formatting in Excel on the results that you got from running your 1010data query.
Leverage Excel's charting capabilities to visually represent the results from your query.
Let's create a drop-down to give the users of our dashboard the ability to select, from a static set of values, the column by which they want to group the results of the tabulation.
The contents of dynamic drop-downs can change based on selections in the dashboard or the results of queries, which means your dashboard will always be up to date even as the data changes. This is historically something very hard to do in Excel-based reporting and a big differentiator with using 1010data and Excel.
We want to be able to run our queries by simply clicking a button on the dashboard.
Utilize more advanced charting techniques in Excel to show the details in the results returned by our 1010data queries.
You can make the Excel Add-in even more dynamic by accessing query code in libraries and blocks on 1010data.
If you are planning to share your workbook with other users, you may want to hide all q-sheets and lock the workbook to prevent accidental edits to your query code.