Hi!
I have a table panel, that looks like this:
I have another datasource, where I can get a single value and I want to display it in footer. I want it to look like this:
Is this possible, and if so, how can I achieve it? Thanks!
Create a dashboard variable to get a single value from another datasource and use it in a query from primary datasource to join it with main query results
I have created a variable and it gets right value from another datasource. I am using infinity plugin as primary datasource and uql parser and if I write | project "org", "address", "income", "$variable_name", I get:
you can use dynamic text plugin now called Business Text to loop over the data. as shown in a previous post reply @fooniquler
Yes, but this doesn’t seem to answer my question. Ebabeshko’s answer looks like the correct solution, but as I wrote, the value taken from another data source is placed in column name, the values ​​​​in this column themselves are empty (not “-”) and nothing is calculated in the total row
1 Like
we dont have access to neither data source so hard to help
what is the relationship between datasource 1 and 2?
There is no relationship between data sources. I get almost all the data I need from the first source, and from the second I need only one value for the “total” row. I understand how to do this using Dynamic Text, but is it possible to add a single value to footer using the default Table Panel?
