Frequency-based worksheet filtering

1. A method comprising:

receiving a first plurality of distinct values having a greatest frequency of occurrence in a data set and responsive to submitting a first search term and column indication, wherein the first plurality of distinct values comprises a number of distinct values less than or equal to a size threshold;

receiving, via a graphical user interface, a selection of a first value from the first plurality of distinct values; and

filtering, based on the selected first value, a worksheet, wherein the worksheet comprises a presentation of the data set.

2. The method of claim 1 , wherein filtering, based on the selected value, the worksheet comprises:

causing a database query based on the selected first value to be issued to a database storing the data set, wherein the database is within a cloud-based data warehouse; and

receiving a subset of the data set responsive to the database query.

3. The method of claim 1 , further comprising:

receiving a second search term;

determining that a response to the second search term is stored;

loading the response to the second search term; and

presenting a second plurality of distinct values included in the response to the second search term.

4. The method of claim 1 , further comprising:

receiving a second search term;

determining that a response to a partial match of the second search term is stored, the response to the partial match comprising a second plurality of distinct values;

loading a subset of the second plurality of distinct values responsive to the second search term; and

presenting, based on a number of distinct values in the second plurality of distinct values falling below the size threshold, the subset of the second plurality of distinct values responsive to the second search term.

5. The method of claim 1 , further comprising:

receiving a second search term;

determining that a response to a partial match of the second search term is stored in memory, the response to the partial match of the second search term comprising a second plurality of distinct values;

sending, based on a number of distinct values in the second plurality of distinct values meeting the size threshold, a request comprising the second search term; and

receiving, in response to the request, a third plurality of distinct values having a greatest frequency in the data set and responsive to the second search term.

6. The method of claim 1 , further comprising:

receiving a selection of a second value from the first plurality of distinct values,

wherein filtering, based on the first selected value, the worksheet comprises filtering, based on the selected first value and the selected second value, the worksheet.

7. The method of claim 1 , further comprising:

identifying, from a stored subset of the data set, a second plurality of distinct values responsive to the first search term; and

presenting the second plurality of distinct values,

wherein presenting the first plurality of distinct values comprises presenting the first plurality of distinct values instead of the second plurality of distinct values.

8. An apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:

receiving a first plurality of distinct values having a greatest frequency of occurrence in a data set and responsive to submitting a first search term and column indication, wherein the first plurality of distinct values comprises a number of distinct values less than or equal to a size threshold;

receiving, via a graphical user interface, a selection of a first value from the first plurality of distinct values; and

filtering, based on the selected first value, a worksheet, wherein the worksheet comprises a presentation of the data set.

9. The apparatus of claim 8 , wherein filtering, based on the selected value, the worksheet comprises:

causing a database query based on the selected first value to be issued to a database storing the data set, wherein the database is within a cloud-based data warehouse; and

receiving a subset of the data set responsive to the database query.

10. The apparatus of claim 8 , wherein the steps further comprise:

receiving a second search term;

determining that a response to the second search term is stored;

loading the response to the second search term; and

presenting a second plurality of distinct values included in the response to the second search term.

11. The apparatus of claim 8 , wherein the steps further comprise:

receiving a second search term;

determining that a response to a partial match of the second search term is stored, the response to the partial match comprising a second plurality of distinct values;

loading a subset of the second plurality of distinct values responsive to the second search term; and

presenting, based on a number of distinct values in the second plurality of distinct values falling below the size threshold, the subset of the second plurality of distinct values responsive to the second search term.

12. The apparatus of claim 8 , wherein the steps further comprise:

receiving a second search term;

determining that a response to a partial match of the second search term is stored in memory, the response to the partial match of the second search term comprising a second plurality of distinct values;

sending, based on a number of distinct values in the second plurality of distinct values meeting the size threshold, a request comprising the second search term; and

receiving, in response to the request, a third plurality of distinct values having a greatest frequency in the data set and responsive to the second search term.

13. The apparatus of claim 8 , wherein the steps further comprise:

receiving a selection of a second value from the first plurality of distinct values,

wherein filtering, based on the first selected value, the worksheet comprises filtering, based on the selected first value and the selected second value, the worksheet.

14. The apparatus of claim 8 , wherein the steps further comprise:

identifying, from a stored subset of the data set, a second plurality of distinct values responsive to the first search term; and

presenting the second plurality of distinct values,

wherein presenting the first plurality of distinct values comprises presenting the first plurality of distinct values instead of the second plurality of distinct values.

15. A computer program product comprising a non-transitory computer readable medium and computer program instructions stored therein that, when executed, cause a computer to carry out the steps of:

receiving a first plurality of distinct values having a greatest frequency of occurrence in a data set and responsive to submitting a first search term and column indication, wherein the first plurality of distinct values comprises a number of distinct values less than or equal to a size threshold;

receiving, via a graphical user interface, a selection of a first value from the first plurality of distinct values; and

filtering, based on the selected first value, a worksheet, wherein the worksheet comprises a presentation of the data set.

16. The computer program product of claim 15 , wherein filtering, based on the selected value, the worksheet comprises:

causing a database query based on the selected first value to be issued to a database storing the data set, wherein the database is within a cloud-based data warehouse; and

receiving a subset of the data set responsive to the database query.

17. The computer program product of claim 15 , wherein the steps further comprise:

receiving a second search term;

determining that a response to the second search term is stored;

loading the response to the second search term; and

presenting a second plurality of distinct values included in the response to the second search term.

18. The computer program product of claim 15 , wherein the steps further comprise:

receiving a second search term;

determining that a response to a partial match of the second search term is stored, the response to the partial match comprising a second plurality of distinct values;

loading a subset of the second plurality of distinct values responsive to the second search term; and

presenting, based on a number of distinct values in the second plurality of distinct values falling below the size threshold, the subset of the second plurality of distinct values responsive to the second search term.

19. The computer program product of claim 15 , wherein the steps further comprise:

receiving a second search term;

determining that a response to a partial match of the second search term is stored in memory, the response to the partial match of the second search term comprising a second plurality of distinct values;

sending, based on a number of distinct values in the second plurality of distinct values meeting the size threshold, a request comprising the second search term; and

receiving, in response to the request, a third plurality of distinct values having a greatest frequency in the data set and responsive to the second search term.

20. The computer program product of claim 15 , wherein the steps further comprise:

receiving a selection of a second value from the first plurality of distinct values,

wherein filtering, based on the first selected value, the worksheet comprises filtering, based on the selected first value and the selected second value, the worksheet.