How to graph Table data created with TOP / SUM sub-query

1

Hi, could you please somebody help me with this I tried all weekend without success :frowning:

data:
Table with number of request for specific domains from DNS server.

Sample data:
INSERT mikrotik,dest=link-a req=10
INSERT mikrotik,dest=link-b req=12
INSERT mikrotik,dest=link-c req=14
INSERT mikrotik,dest=link-a req=4
INSERT mikrotik,dest=link-c req=7

destination | req |
link-a      | 10  |
link-b      | 12  |
link-c      | 14  |
link-a      | 4   |
link-c      | 7   |

Goal:
Graph top 2 domains

I am able create table with this SQL:

SELECT TOP(total_24h,dest,2) FROM (SELECT SUM(req) as total_24h
      FROM mikrotik 
      WHERE time > now() - 24h 
      GROUP BY dest
)

destination | req |
link-c      | 21  |
link-a      | 14  |

Problem:
I am not able to graph this table probably because when I change format from Table to Time Series my table looks like this:

time        | mikrotik.top | mikrotik.dest |
2020-09-06* |      14      | link-a        |

Many thanks for any help here.