I want to compute the total revenue per device on the last 7 days

I want to compute the sum(revenue) per device on the last 7 days .I am using database sql druid and tool is apache superset.


This is a companion discussion topic for the original entry at https://stackoverflow.com/questions/73876042/i-want-to-compute-the-total-revenue-per-device-on-the-last-7-days