If the MC has a panel that is close to what you need, copy it to your own app and modify it to do what you want.
Consider starting with the "Daily License Usage" panel in the "License Usage - Previous 30 Days" dashboard.
Thank you for the quick reply @richgalloway
I used the below query and got the intended results based on source. However, I have a followup question.
The query gives 10 results and the rest of the results go to "OTHER", What is the criteria on what sources are shown and what sources are included in OTHER.
dmc_licensing_usage_all(dw07apl43.cityofchicago.org, dmc_licensing_stack_size_srch, dw07apl43.cityofchicago.org, "s", "") | sort -_time