Erste Analyse der Audio-Daten des BeABee-Projekts

Dear @Diren,

maybe you can help @Jimakos here by giving him any hint about how you did it within Grafana?

With kind regards,
Andreas.

I 'm gonna check my query the next time I am in my office (currently in home office).
For now: Do I understand correctly that you have the magnitude on the y-scale, and the frequency encoded in the color? Maybe, you just want to switch this around? I think that’s common practice to have frequency on the y-scale. Can you just exchange magnitude and frequency in your query?

1 Like

Hi Diren,

in heatmap I think the color encodes the number of the respective magnitudes in the specific bucket. So, for example in the picture above, the reddish area in the yellow region shows how many magnitude values of around 100 (y axis) are in the same bucket (the bucket is a magnitude range e.g. 90-100). As you see also from my query I do not fetch the frequency columns (mainly because I havent’s succeeded doing something meaningful with them).

All in all, I need a different encoding: the y Axis should show the frequencies and the color should correspond to the magnitudes.

Ok, found my query.
I used an own column for each frequency, and the values within the columns are amplitudes.
so something like this:

Time |  0        | 20         | 40         | 60         |
t1   |    3      |     15     |     1000   |     120    |
t2   |     4     |     32     |     2002   |     233    |
t3   |     0     |     36     |     567    |      56    |

Then my query looks like this:

SELECT "0","20","40","60","80","100","120","140","160","180","200","220","240","260","280","300","320","340","360","380","400","420","440","460","480","500","520","540","560","580","600","620","640","660","680","700","720","740","760","780","800","820","840","860","880","900","920","940","960","980","1000"
FROM "value" WHERE $timeFilter

Could you restructure your table in a similar way?

Or maybe this helps you with your table structure?

Sorry, I don’t have much time at the moment, so I can’t really try it out.

2 Likes

It’s neither the query nor the database; it is the plugin which doesn’t know what you want from its Y-axis. There are no values in the traditional sense, there are buckets, already provided by your data. So for this case the Grafana Heatmap-plugin needs to know about this, and this can be stated under Visualization > Data format > Format: Time series buckets. Every field-series your query returns will be now converted into a dedicated row and coloured by its value.

2 Likes