[Plugin Update: 2021] TechBlocks Charts and Graphs (Chart.js)

Hi @princesssoria13 – thanks for reaching out!

Currently, the Funnel Chart plugin is separate, but I am considering adding it to the main Charts app soon. Will keep you posted if I do! You can learn more about the Sales and Conversion Funnel Chart plugin here: [New Plugin] Sales & Conversion Funnel

Alex

I see. Thank you. I want to create a sales dashboard that has all of the above charts

hi @alex4
thanks for helping, i had the same problem before, and do you know how to convert it back into readable date on the displayed chart

Hey @joshuaanastasiusn – thanks for the question! What chart type are you using?

It looks like you have the time set as Unix time – you should format it in your Bubble expression to be whatever date format you need (e.g. mm/d/yyyy). I’m happy to take a look at your editor if you’d like; feel free to DM me a link if so.

Alex

Good job with the bubble chart. I just tried it and it works really great!

1 Like

hi @alex4 thanks for your fast response,
I tried to display price movement using a bar/line chart daily, and I tried to use the normal search function " search for historical price’s date" for date, but it displays wrongly. For example:

expected result:
{1 Jan 2020 10 pm, 2100}
{2 Jan 2020 10 pm, 2200}
{3 Jan 2020 10 pm, 2500}
but it displays wrongly on the chart as:
{1 Jan 2020, 2100}
{10 pm 2020, 2200}
{2 Jan 2020, 2500} and so on
seems like the chart read one date row as its day and its time separately
that’s why I’m using your extract UNIX timestamp, and now the data display correctly but seems like no option to format UNIX time back to a readable date.
let me know if I miss something

image

@alex4 I might be missing something obvious, but I can’t seem to find a setting (specifically on a Scatterplot in this case) that would allow me to show labels on the chart at all times rather than having to hover over data points to bring up a tooltip.

For example, here is a chart I’ve created using your plugin:

And here is the same chart in Google Sheets that I am trying to recreate:

Any advice or plugin enhancements to enable this would be amazing.

Thanks,
Kent

1 Like

How many data sets can I add to the charts?

1 Like

@relingok thanks for the great feedback on the Bubble Chart! Happy to hear it’s working well for you!

@joshuaanastasiusn I see, the most likely reason that your dates are displaying incorrectly is because the chart uses commas to separate each value and each item in your list has a comma in there already. For example, “1 Jan 2020 10pm, 2100” so it’s interpreting that item as two items “1 Jan 2020 10pm” and “2100”. Formatting each date item so that it does not have an extra comma in there (e.g. you could replace “,” with “-”). Happy to take a look at your editor to assist if needed – feel free to DM me a link to it!

@Kent I’ll take a look at your request today and get back to you!

1 Like

@Kent – currently, you can’t add labels to the Scatter and Bubble Charts, but look forward to an update next week that enables this! I’ll make an announcement and tag you once that’s ready.

@princesssoria13 – you can add an infinite number of data series to the charts via workflow actions, where you customize the color and data on the charts. This applies to most charts as long as multiple series is relevant. What type of chart are you adding?

2 Likes

@alex4 One more feature request for you: when using a workflow action to “remove a data series” (specifically for a stacked bar chart in this case) would it be possible to also remove the series name from the chart legend? I am dynamically adding/removing series to a chart based on user selections (i.e. using dropdowns and checkboxes) but once a series is added, its entry in the legend remains visible despite removing the series via a workflow. Alternatively, is there some kind of command that can be executed to force refresh the chart and redraw the legend?

Thanks as always,
Kent

Hi @alex4, thanks for creating this plugin. I am trying to get basic functionality for the donut/pie chart. I assume this is something obvious I have overlooked.

To test the most basic functionality, I have selected “Chart - Pie/Donut” from the elements selector, and clicked on a space within a nested group (without changing any of the default attributes for the element). The preview looks like this.

Screen Shot 2021-05-21 at 10.37.23 AM

I have tried copy/pasting from the demo page, as well as downgrading the version to match the demo page (2.41.2). Any help would be greatly appreciated!

Best,
Chris

1 Like

Hey @Kent – thanks for explaining the use case here and spotting that issue. I’ll be adding another backlog item to update the “remove data series” action to remove the series from the legend – let you know when it’s ready.

@chris.stevenson welcome to the Bubble forum! Strange that you’re experiencing that issue with the Donut Charts – can you DM me a link to your editor? I’d like to take a look since I can’t reproduce the issue on my end.

Alex

1 Like

Thanks for the response! My forum account is too new to DM, but my coworker is sending you a message now.

1 Like

I see. Thank you, nice job with the add-on!

1 Like

Thanks @chris.stevenson and @princesssoria13 I appreciate the kind words. Enjoy!

Hey @Kent – following up on this. Are you needing the data label to be the series name here? Would you need the data label to provide the X or Y value as well?

Cheers,
Alex

@alex4 for this particular use case the series name would work for the diamonds shown in the chart; however for the large circles I would ideally be able to designate another source (as you can see in the Google Sheets version, each of these large circles receives a number, i.e. 0, 1, 2, 3, 4, 5).

For background, this chart shows various portfolios (identified as 0, 1, 2, 3 … 10) which consist of different weightings of underlying asset classes (the diamonds). I want the labels for the asset classes to show their names (i.e. the Series Name) but for the Model portfolios to show a simple number.

I could envision other use cases where being able to reference the X/Y values would certainly be helpful as well but my current use case is focused on the series name (with the nuance of also hoping to assign a custom value as well for certain series).

Happy to provide additional feedback as needed if the above isn’t clear.

Thanks!
Kent

1 Like

@alex4

Thank you for your great plugin.

The Y-axis minimum number of the graph can be fixed in specific number?
It is better that the number of the Y-axis of the graph starts from specific number.

Thanks!

1 Like

Update in v3.0.6: Added Data Labels for Scatter Charts

Just published a new version of the plugin that offers data labels for Scatter Charts. This is a bit more complex than the other charts’ data labels, since you can customize which data shows up on the data label (i.e. whether the series name, x value, and/or y value show up and in what order). Try it out an let me know if you spot any issues!

@kent FYI^^! This is just a first version of the feature, but how does this solution work for your use case? I’ll be adding this for Bubble Charts as well soon.

@fact-field – thanks for the feedback! You can currently set the number on the Y-axis to start from a minimum value. Let me know if you need help doing so and if I understood your question correctly!