Grouping by time from ulr source


#1

Hi,

Is there a way to create queries on data provided by URL data source? I am new to redash and i wanted to visualize some data from my REST service.

I have a service that provides access to data only via REST (it holds everything in memory). I created a proxy that maps response to format supported by redash and i can succesfully display the data as table in redash. If i want to display data like - number of rows with specific hour i have to map this in my proxy, or i can do it in redash?
Something like - each row represent event and i want to display number of events in specific hour.


#2

You can use the Query Results feature:

https://redash.io/help/user-guide/querying/query-results-data-source

So your process will be:

  1. Load the data from the API into a query.
  2. Use Query Results data source to query the data from step 1.

#3

yes, after playing more with tool I have found same solution