# \#bi **URL:** https://community.grafana.com/tag/bi/52.md [Latest](https://community.grafana.com/latest.md) · [Categories](https://community.grafana.com/categories.md) · [Tags](https://community.grafana.com/tags.md) --- ## [Long numbers are not retrieved with the correct format even with 'string' option as the unit](https://community.grafana.com/t/long-numbers-are-not-retrieved-with-the-correct-format-even-with-string-option-as-the-unit/60420)
**Author:** [@rcmv](https://community.grafana.com/u/rcmv)\ **Replies:** 3\ **Last updated:** [March 18, 2025, 2:30am UTC](https://community.grafana.com/t/long-numbers-are-not-retrieved-with-the-correct-format-even-with-string-option-as-the-unit/60420 "2025-03-18T02:30:52Z")
Hi! I’m developing some queries on grafana that deal with long numbers (19 digits). Usually, if I don’t force these long numbers to be returned as a string they are rounded and I’m not able to see the precise number. Th… --- ## [Grafana or PowerBI](https://community.grafana.com/t/grafana-or-powerbi/141784)
**Author:** [@matt2](https://community.grafana.com/u/matt2)\ **Replies:** 3\ **Last updated:** [January 30, 2025, 9:11pm UTC](https://community.grafana.com/t/grafana-or-powerbi/141784 "2025-01-30T21:11:48Z")
Hi All We presently have data on some older SQL servers, and use SSRS for most of our reports. Someone started using PowerBI to create some reports, which management like - however it is limited to just that one user. R… --- ## [Merge series map in Grafana Echarts plugins](https://community.grafana.com/t/merge-series-map-in-grafana-echarts-plugins/111936)
**Author:** [@phutoan312991](https://community.grafana.com/u/phutoan312991)\ **Replies:** 4\ **Last updated:** [January 15, 2024, 6:43am UTC](https://community.grafana.com/t/merge-series-map-in-grafana-echarts-plugins/111936 "2024-01-15T06:43:54Z")
Hi all, I am plotting box-plot using Echarts plugins: My sample box-plot is here: Examples - Apache ECharts And my problem is I can’t import data into echarts plugins: My code: data.series.map((s) =\> { if (s.refID… --- ## [KQL doesn't render barchart](https://community.grafana.com/t/kql-doesnt-render-barchart/53714)
**Author:** [@kequach](https://community.grafana.com/u/kequach)\ **Replies:** 1\ **Last updated:** [November 26, 2023, 7:34pm UTC](https://community.grafana.com/t/kql-doesnt-render-barchart/53714 "2023-11-26T19:34:56Z")
I’m running a barchart visualization that always gives me an error (the plot is not defined) on the dashboard: I see the same when I click on edit: But when I switch from table view and back, the visualization works… --- ## [Does Grafana support chained variables with timescaledb?](https://community.grafana.com/t/does-grafana-support-chained-variables-with-timescaledb/59242)
**Author:** [@programm1032](https://community.grafana.com/u/programm1032)\ **Replies:** 2\ **Last updated:** [April 20, 2022, 4:10pm UTC](https://community.grafana.com/t/does-grafana-support-chained-variables-with-timescaledb/59242 "2022-04-20T16:10:09Z")
Hello Everyone, I have been trying to automatically get the columns from a table to be shown as variables in grafana. This worked pretty good to me: SELECT column\_name FROM information\_schema.columns WHERE table\_name:… --- ## [Dashboard refresh clears table column filter](https://community.grafana.com/t/dashboard-refresh-clears-table-column-filter/57999)
**Author:** [@pr1malc0de](https://community.grafana.com/u/pr1malc0de)\ **Replies:** 7\ **Last updated:** [March 15, 2022, 7:34am UTC](https://community.grafana.com/t/dashboard-refresh-clears-table-column-filter/57999 "2022-03-15T07:34:58Z")
What Grafana version and what operating system are you using? 8.1.2 What are you trying to achieve? Filter columns that stick when dashboard refreshes preferably per user How are you trying to achieve it? by applyi… --- ## [How to avoid Grafana handling NULL values from Google BigQuery as 0](https://community.grafana.com/t/how-to-avoid-grafana-handling-null-values-from-google-bigquery-as-0/60488)
**Author:** [@smdb](https://community.grafana.com/u/smdb)\ **Replies:** 2\ **Last updated:** [February 23, 2022, 1:50pm UTC](https://community.grafana.com/t/how-to-avoid-grafana-handling-null-values-from-google-bigquery-as-0/60488 "2022-02-23T13:50:00Z")
I have the doitintl BigQuery plugin (v2.0.2) installed for my Grafana instance (v8.2.7). My SQL query is based on multiple tables and is joined with a full outer join on the timestamp column. Therefore, I have some null … --- ## [Limit Bar Chart to top N values](https://community.grafana.com/t/limit-bar-chart-to-top-n-values/53636)
**Author:** [@kon3dos](https://community.grafana.com/u/kon3dos)\ **Replies:** 1\ **Last updated:** [January 20, 2022, 8:05pm UTC](https://community.grafana.com/t/limit-bar-chart-to-top-n-values/53636 "2022-01-20T20:05:19Z")
Hey everyone, I write raw SQL queries to visualize data from my DB. My data have often multiple rows that would be overkill to preview in Charts, therefore, I apply LIMIT to my SQL queries. However, I want to be able t… --- ## [Examples of macro usage $\_\_timeGroup with Google BigQuery Datasource?](https://community.grafana.com/t/examples-of-macro-usage-timegroup-with-google-bigquery-datasource/59270)
**Author:** [@didiermonsergent](https://community.grafana.com/u/didiermonsergent)\ **Replies:** 0\ **Last updated:** [January 19, 2022, 8:54am UTC](https://community.grafana.com/t/examples-of-macro-usage-timegroup-with-google-bigquery-datasource/59270 "2022-01-19T08:54:57Z")
Hi all, I use Grafana with the Google BigQuery datasource. Do you have examples of usage, syntax of the $\_\_timeGroup macro ? Regards, Didier --- ## [Grafana charts grouped by month with Google BigQuery Datasource?](https://community.grafana.com/t/grafana-charts-grouped-by-month-with-google-bigquery-datasource/59269)
**Author:** [@didiermonsergent](https://community.grafana.com/u/didiermonsergent)\ **Replies:** 0\ **Last updated:** [January 19, 2022, 8:44am UTC](https://community.grafana.com/t/grafana-charts-grouped-by-month-with-google-bigquery-datasource/59269 "2022-01-19T08:44:07Z")
Hi all, I use Grafana with the Google BigQuery datasource. I can’t display a graph with a monthly distribution (with the macro $\_\_timeGroup) My query : SELECT \* FROM ( SELECT $\_\_timeGroup(usage\_start\_time, 1M), p… --- ## [Get Number Of new users in grafana stat with my sql data source](https://community.grafana.com/t/get-number-of-new-users-in-grafana-stat-with-my-sql-data-source/59153)
**Author:** [@chaitanya1](https://community.grafana.com/u/chaitanya1)\ **Replies:** 0\ **Last updated:** [January 17, 2022, 2:33pm UTC](https://community.grafana.com/t/get-number-of-new-users-in-grafana-stat-with-my-sql-data-source/59153 "2022-01-17T14:33:18Z")
Hi i want to see number of new borrowers in grafana stat panel and also when i select date range from filter then data will accordingly change. My Database - MySql And Below is the screen shot i attached which contains… --- ## [When mySql datasource to be migrated to React](https://community.grafana.com/t/when-mysql-datasource-to-be-migrated-to-react/56933)
**Author:** [@yusufmulthan](https://community.grafana.com/u/yusufmulthan)\ **Replies:** 0\ **Last updated:** [November 30, 2021, 8:42am UTC](https://community.grafana.com/t/when-mysql-datasource-to-be-migrated-to-react/56933 "2021-11-30T08:42:38Z")
When is the Grafana team planning to migrate MySQL datasource plugin to React (With QueryEditor and latest components) --- ## [Display hyperlinks from Google Sheets datasource](https://community.grafana.com/t/display-hyperlinks-from-google-sheets-datasource/53942)
**Author:** [@adam5840](https://community.grafana.com/u/adam5840)\ **Replies:** 1\ **Last updated:** [October 21, 2021, 9:22pm UTC](https://community.grafana.com/t/display-hyperlinks-from-google-sheets-datasource/53942 "2021-10-21T21:22:50Z")
Is it possible to bring across hyperlinks from Google Sheets cells to Grafana table cells via the Google Sheets datasource plugin? Many thanks, --- ## [Table panel sometimes show corrupted data (duplicated rows)](https://community.grafana.com/t/table-panel-sometimes-show-corrupted-data-duplicated-rows/53063)
**Author:** [@amirtavizi](https://community.grafana.com/u/amirtavizi)\ **Replies:** 1\ **Last updated:** [October 21, 2021, 8:40pm UTC](https://community.grafana.com/t/table-panel-sometimes-show-corrupted-data-duplicated-rows/53063 "2021-10-21T20:40:41Z")
Hi everybody We use a Grafana dashboard (Table panel) for live monitoring our device’s data that collection via opcua Telegraf and InfluxDB that fetch and update table every 5 seconds. Sometimes Table Panel show corrup… --- ## [State Timeline not connecting](https://community.grafana.com/t/state-timeline-not-connecting/54223)
**Author:** [@masonje](https://community.grafana.com/u/masonje)\ **Replies:** 3\ **Last updated:** [October 21, 2021, 5:03pm UTC](https://community.grafana.com/t/state-timeline-not-connecting/54223 "2021-10-21T17:03:19Z")
I have a state timeline I have mostly set up. It’s SQL based. I have this working as expected in another Prometheus data based timeline. The data from the query basically flips the bit on or off. It’s kinda working, but … --- ## [Grafana as a BI tool](https://community.grafana.com/t/grafana-as-a-bi-tool/53998)
**Author:** [@xbalayer](https://community.grafana.com/u/xbalayer)\ **Replies:** 1\ **Last updated:** [October 7, 2021, 1:47am UTC](https://community.grafana.com/t/grafana-as-a-bi-tool/53998 "2021-10-07T01:47:53Z")
Grafana is a great tool to view live data and to some extent can be used as a BI tool for basic things. Is there any interest on the development side to expand Grafana to the BI world? For those of us who are intereste… --- ## [State Timeline ignore events shorter than X minutes](https://community.grafana.com/t/state-timeline-ignore-events-shorter-than-x-minutes/51309)
**Author:** [@adrianatcrimsonauzre](https://community.grafana.com/u/adrianatcrimsonauzre)\ **Replies:** 1\ **Last updated:** [October 4, 2021, 11:17pm UTC](https://community.grafana.com/t/state-timeline-ignore-events-shorter-than-x-minutes/51309 "2021-10-04T23:17:17Z")
Is there a way to ignore events shorter than X minutes in the State Timeline? Example: a device is online for 2 hours, then offline for 3 seconds, then back online for another 5 hours. Ignore states that lasts for less … --- ## [Newbie Struggling to Use Database Data as Opposed to Performance Data](https://community.grafana.com/t/newbie-struggling-to-use-database-data-as-opposed-to-performance-data/54015)
**Author:** [@JueBob](https://community.grafana.com/u/JueBob)\ **Replies:** 1\ **Last updated:** [September 30, 2021, 11:17pm UTC](https://community.grafana.com/t/newbie-struggling-to-use-database-data-as-opposed-to-performance-data/54015 "2021-09-30T23:17:15Z")
I’m trying to produce a graph type dashboard that presents me details of the number of products sold in each product group on a daily basis. The datasource I’m using is SQL Server, as my database is held there, and … --- ## [Hiding a series in the new "Time Series (beta)" panel (Grafana 7.5.6)](https://community.grafana.com/t/hiding-a-series-in-the-new-time-series-beta-panel-grafana-7-5-6/53044)
**Author:** [@andypellew](https://community.grafana.com/u/andypellew)\ **Replies:** 9\ **Last updated:** [September 28, 2021, 10:07pm UTC](https://community.grafana.com/t/hiding-a-series-in-the-new-time-series-beta-panel-grafana-7-5-6/53044 "2021-09-28T22:07:05Z")
We’re running 7.5.6 viewing using Chrome browser What are you trying to achieve? I am looking to upgrade an existing dashboard replacing the existing “Graph” visualisation with the new “Time Series (beta)”. We u… --- ## [Grafana Geomap with GPS from Loki](https://community.grafana.com/t/grafana-geomap-with-gps-from-loki/53464)
**Author:** [@Wertster](https://community.grafana.com/u/Wertster)\ **Replies:** 0\ **Last updated:** [September 17, 2021, 4:42pm UTC](https://community.grafana.com/t/grafana-geomap-with-gps-from-loki/53464 "2021-09-17T16:42:04Z")
Hi all, I’ve recently put together a promtail, Loki, grafana docker based system and all is working beautifully! One log I am acquiring into Loki contains lines with json fragments including latitude and longitude coord… --- ## [Dymaxion projection in geomap?](https://community.grafana.com/t/dymaxion-projection-in-geomap/53423)
**Author:** [@karstenh](https://community.grafana.com/u/karstenh)\ **Replies:** 0\ **Last updated:** [September 17, 2021, 4:42am UTC](https://community.grafana.com/t/dymaxion-projection-in-geomap/53423 "2021-09-17T04:42:45Z")
hello world, got some questions about the usability of grafana/geomap for a current project: 1# someone ever thought of or tried to use buckminster fullers dymaxion map projection to render the worldmap in geomap? do…