- 1188 Views
- 2 replies
- 10 kudos
How to improve visualization and dasboard concepts?
How to improve visualization and dasboard concepts?
- 1188 Views
- 2 replies
- 10 kudos
- 10 kudos
Hi @Priyadarshini G​ Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question. Thanks.
- 10 kudos
- 5096 Views
- 3 replies
- 1 kudos
When I aggregate over more data, I get the below error message. I've tried multiple ways of diagnosis like going back to a version I know it was w...
When I aggregate over more data, I get the below error message. I've tried multiple ways of diagnosis like going back to a version I know it was working fine (but still got the same error below). Please advise as this is a critical report where the b...
- 5096 Views
- 3 replies
- 1 kudos
- 1 kudos
@Jeff Wu​ :The error message suggests that there is a syntax error in a SQL statement, specifically near the end of the input. Without the full SQL statement or additional information, it's difficult to pinpoint the exact cause of the error. However,...
- 1 kudos
- 1692 Views
- 2 replies
- 0 kudos
Visulization only from sample of data
When I display dataframe and add visualization, I can see a preview from only a sample of data, and when I confirm it, it is counted from all of the data. Until now, everything is fine. However, when I change the dataframe, the visualization is incon...
- 1692 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @Ondrej Lostak​ Hope everything is going great.Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so...
- 0 kudos
- 5174 Views
- 5 replies
- 6 kudos
Error While Rendering Visualization -- Map (Markers)
I have a table with latitude and longitude for a few addresses (no more than 10 at the moment) but when I select the appropriate columns in the visualization editor for Map (Markers) I get an message that states "error while rendering visualization"....
- 5174 Views
- 5 replies
- 6 kudos
- 3281 Views
- 1 replies
- 0 kudos
How can I create grouped bars that are also stacked visualization?
I wish to create a visualization combined of grouped bars, and also have those bars stacked.Attached is a sketch of the final result I am interested in.I am also attaching my sql because I'm not sure if I should "group by" in the query or in the visu...
- 3281 Views
- 1 replies
- 0 kudos
- 0 kudos
try to use asc or dsc keyword ,maybe it worked
- 0 kudos
- 8650 Views
- 6 replies
- 7 kudos
Resolved! Wrong X-Axis Order when Visualization is Put on Dashboard
I have a visualization in which the X-axis values are displayed correctly in the Query Editor, in the order produced by the SQL query. However, when I add the visualization to a dashboard, the values are suddenly not sorted anymore.How is this possib...
- 8650 Views
- 6 replies
- 7 kudos
- 7 kudos
We have further analyzed the visualization problem and found two solutions.The original visualization consists of 1 series and has aggregation enabled in the UI (but is unused, since the query itself aggregates already).We found that the following tw...
- 7 kudos
- 15408 Views
- 12 replies
- 8 kudos
Grafana + databricks = True?
We have some timeseries in databricks, and we are reading them into powerbi through sql compute endpoints. For timeseries powerbi is ... not optimal. Earlier I have used grafana with various backends, and quite like it, but I cant find any way to con...
- 15408 Views
- 12 replies
- 8 kudos
- 8 kudos
There is now an Open-Source Grafana Databricks backend plugin available.https://github.com/mullerpeter/databricks-grafana
- 8 kudos
- 5390 Views
- 7 replies
- 2 kudos
How do I enable new Visualization tools in my Databricks notebooks?
Databricks released new visualization toolshttps://docs.databricks.com/notebooks/visualizations/index.htmlBut I don't see them in my notebook (DBR 10.4) nor I can find out how to enable them. How do I use the new tools?
- 5390 Views
- 7 replies
- 2 kudos
- 2 kudos
@Atanu Sarkar​ , I am still not seeing this. I am running a cluster on runtime 10.4 LTS ML. The "Legacy Visualizations" are the only option available. This feature should be fully deployed, yes?
- 2 kudos
- 9016 Views
- 4 replies
- 5 kudos
Resolved! Is it possible to show multiple cmd output in a dashboard?
I have a loop that outputs a dataframe for values in a list; basically a loop. I can create a dashboard if there is only one df but in the loop, I'm only able to see the charts in the notebook if I switch the view to charts not in the dashboard. In t...
- 9016 Views
- 4 replies
- 5 kudos
- 5 kudos
If you want to be able to easily run and kill multiple process with ctrl-c, this is my favorite method: spawn multiple background processes in a (…) subshell, and trap SIGINT to execute kill 0, which will kill everything spawned in the subshell group...
- 5 kudos
- 2992 Views
- 4 replies
- 7 kudos
Resolved! Visualization of Structured Streaming in job.
Does Databricks have feature or good pattern to visualize the data from Structured Streaming? Something like display in the notebook.
- 2992 Views
- 4 replies
- 7 kudos
- 10192 Views
- 2 replies
- 0 kudos
Resolved! Change size or aspect ratio of ggplot visualizations
I understand that plots in R notebooks are captured by a png graphics device. Is there a way to set the size or the aspect ratio of the canvas? I understand that I can resize the rendered .png by dragging the handle in the notebook, but that means I...
- 10192 Views
- 2 replies
- 0 kudos
- 0 kudos
Hi @sdaza​ , the answer above didn't change the size somehow, or perhaps I was putting it in the wrong place? I entered it in a new cell before the %sql cell with the plot chart.
- 0 kudos