Tips and tricks

When you want to quickly test whether a certain visualization is suitable for your needs, but you don't have the time to create the long and complex query that will provide you the necessary results in the format the visualization expects, you can simply mock the result set and do your quick and dirty test.

Here is an example, Suppose I want to test the funnel visualization. I know that the funnel expects a column for the Funnel Steps and another column for the Funnel Step Value. I select the internal Redash data source, called Redash metadata (no worries, we don't need anything from the data in the data source itself), and execute the following query:

SELECT 'Bought Stop Watch' AS fun_step,
       10000 AS
VALUES
UNION
  (SELECT 'Bought Running Shoes' AS fun_step,
          8000 AS
   VALUES)
UNION
  (SELECT 'Bought Running Shorts&apos...