Hi everyone 👋 good data noob here 🙇 I’m trying to plot an orders table to a bubble chart is it possible to have non-metric X and Y axises? I just want to show the revenue of days (as X axis) and hours (as Y axis) when I drop a column to this area, it will be either sum or count 😅 Thanks!

Hello Connor, Thank you for reaching out to us. First, I would like to ask if you have a specific time range for your sales, or are you looking to see revenue generated for each hour? What format do you use for your hours? Your answers will help us replicate your scenario and provide better assistance. As a note, according to https://www.gooddata.com/docs/cloud/create-visualizations/visualization-types/bubble-charts/, both the X and Y axes must contain numerical values for a proper comparison. We can help you with your desired visualization, and we can explore other options as well. Additionally, creating a Custom Visualization, as mentioned in https://www.gooddata.com/docs/gooddata-ui/latest/learn/visualize_data/create_custom_visualizations/which, could be beneficial for your case.

Hi Mauricio, thanks for you replying! Both X axis and Y axis won’t be numeric type, X axis would be something like 2024-04-01, 2024-04-02, 2024-04-03, and Y axis would be 01:00, 02:00, … 13:00 to present the hour of a day. I think the custom visualization would be the way to go 🤔

Can we create a transformation somewhere where we can extract the data and times from a timestamp(in postgres) to something like 1, 2, 3, 4 for the days and 0-1440 for the minutes

Hi Connor, thank you for the information and format. With that, I will create dummy data to find a solution, and I will reach out to you for help. I will keep you posted.

We're trying exploring the Gooddata trial and are trying to figure out what the limitations are and which of our dashboards we're able to recreate

Hi Sebastian, Thank you for your help actually I was thinking something like that, if the Bubble is just for visualisation I think it could work.

Screenshot 2024-11-19 at 3.41.23 PM.png,Screenshot 2024-11-19 at 3.41.35 PM.png,Screenshot 2024-11-19 at 3.42.00 PM.png

Hi Connor and Sebastiaan, I have been working on your request in my test environment. I created a dummy table with the following format:

date, dayofmonth, hourofday, totalsale
2024-08-16 20:08, 16, 20, 5958.3

In this table, I have extracted the numerical values for the day of the month and the hour from the date column. However, I am still unclear about one aspect: if there are two sales, such as at 14:20 and 14:55, will both sales be represented in the same time bubble for the 14th hour, right? I have almost finished what you asked for, but I'm currently working on the hour of the day axis, which is counting how many hours or sales were made each day. As you can see I also applied a filter for the year and month. Please confirm my previous question. Thank you!

👏

Each datapoint would have their own bubble. We don't need the number inside of the bubble and we don't have a series(different color)

Hi, Thanks so much for your reply! Just to clarify, you're looking to visualize the density and "size" of the bubbles for daily/hourly sales over the course of a month, right? Regarding the click function question I’m happy to let you know that this can be done using Interaction features like Drilldown! You can check out the documentation here: https://www.gooddata.com/docs/cloud/create-dashboards/drilling-in-dashboards/set-drill-into-insight/. Here's what I've been working on: I created a dummy table with thousands of records in the format we talked about. For the X-axis, I used Day of Month, and I chose "average" since the sales on the same day at different hours balance out to the same day-average. I’m still figuring out the best approach for the Y-axis. I've experimented with it as both an attribute and a fact without any filters applied. For the metric, I originally summed the sales, but I understand now that you need a separate bubble for each individual sale. The "view by" option is set to group by Day of Month, as you can see in the screenshot. Plus, I added a filter at the top so you can view each month within each year, and easily change it. I’ll keep testing with this new info and will keep you in the loop on how it goes!

Great, thank you

Hi, good news.. I think I got what you want. Solution was to change the view by to 'minute' and I created a new column where I transformed, as you initially suggested, the hour of the day to minutes (0-1440) and then I create a metric to have this value in decimal hour by simply dividing over 60, maybe you can do the same step before directly in the new column of your table. And the three metrics were in 'average'. Regarding the color of the bubbles I will investigate more and let you know!

🔥

Hi Connor and Sebastiaan, I was investigating about the color of the bubbles and for now the only option is to doing by the GoodData.UI (SDK-UI). As reference you can see this documentation https://www.gooddata.com/docs/gooddata-ui/9.7/references/visual_components/bubble_chart/ I hope the bubble chart is how you wanted! Cheers!

Thank you so much for all the effort! Only question is if we can somehow show them in am/pm (that's the US format)

Hi, I think a way how to achieve this is playing with 'Custom Format' and in 'Configuration' choose 'inherit' then in custom you can define it something like:

[>=12]{{{1|12|0}}} pm;
[<12]{{{|12.|0}}} am;

You can have a look this documentation https://www.gooddata.com/docs/cloud/create-metrics/format-numbers/#unit-conversion-in-metric-formatting to get an idea. Good luck, I hope will help you!