Hello Community , im a beginner and my goal is to create a dashboard for KPIs with my DB
So my question is, i cant use the plugin pie chart , because im missing a time column? but how should i add that?
Select cast(nn.SoftwareID as nvarchar(36)), software.Name , software.Version, software.Producer, count(*) as Anzahl From oems_client_nn_software as nn
Left Join oems_software as software on software.SoftwareID = nn.SoftwareID
GROUP BY nn.SoftwareID, software.Name , software.Version, software.Producer
this is a example with this i can see my data via grafana when i use “table” but not when i try to use a pie chart
What am i missing?
Hope someone can help