I attached several pictures with my sql question.
The problem is , is that I need to graph all of my data without summing all of the rows with the same time. How do I go about this?
I’m trying to show all of my data grouped by p1 column “Automatas”, When im trying to show data where p1 is equal to more than 1 value It sums all values.( if p1= to 1 value then it doesnt sum)
I’ve tried to make the values differ by 10 miliseconds, but it shows the same time on the graphs and still truncates the rows… wth?
Okay i’ve made it that it doesnt truncate the rows, but how do I write an sql question to display multi series charts?
You are probably seeing this issue:
https://github.com/metabase/metabase/issues/12729 - upvote by clicking on the first post
But I don’t understand what you’re trying to do or what the problem is besides that.
Yes, it’s the same issue, The problem now I’m having is that I need to visualize the selected p6,p7,p8,p9 parameters when I filter by my p1 parameter. For example when p1=14;19 it doesnt show me 8 graphs, instead it shows the p6,p7,p8,p9 graphs but somewhat summerised. Should I create seperate questions and combine them or what should I do?
Thank you for your help, Flamber
@Martynas You cannot use the same Field Filter multiple times and have it activate grouping.
Then you would need something like this:
https://github.com/metabase/metabase/issues/13148 - upvote by clicking on the first post
Perhaps multiple questions will work and then combining them on a dashboard, but that might be a filter mess.
It’s difficult to completely know what’s the best solution, since only you have access to the data.
But showing this amount of data, at this interval, is probably not Metabase’s strength.