Clustered bar charts

[Joe_Ojay]

Hello,

IS there a work around to produce clustered bar charts or stacks? In the language of appsheet, this would be multiple group aggregates.

Essentially I’m looking to acheive the thermometer style bar chart or what also is acheived in Excel by adding a secondary verticle axis, features that you would typically find in a sales type bar chart. For example, on your x-axis you would have the months of the year and for each month a bar for target sales and one for actual sales.

[Joe_Ojay]

Hello?

[Kirk_Masden]

Hi Joe!

Sorry you haven’t gotten a response. I’ve been using AppSheet for a few years now and have gotten lots and lots of help here over the years. Usually, people at AppSheet are pretty good about responding. Occasionally, however, if no one who sees your post knows the answer, a post can go for a while without a response.

I don’t happen to have the answer to your question but I hope someone will chime in soon. Good luck with your app!

[Aleksi]

@Joe_Ojay Do you have any sample chart that you could share? It would be easier to think what you are looking for?

[Jonathon]

In addition to Aleksi’s question, is your x-axis fixed (there will only ever be a bar for each month, or some set of months)?

If the x-axis can be fixed, then this is almost certainly doable with SVG, in the event that it can’t be done natively with AppSheets charts.

Dynamic SVG:

Dynamic SVG graphics Tips & Tricks 💡

Recently I have been using Scalable Vector Graphics (SVG) in my applications, in place of typical raster images or even text in some cases. SVG graphics are defined through code, as per the examples here: https://www.w3schools.com/graphics/svg_examples.asp As the images are defined with code, you can CONCATENATE() strings of code together while including application variables, to make the images dynamic. In this way, you could have animated images which react to user input. Another thing to no…

[Kirk_Masden]

I forgot about SVG. I was asking about another graph related question on another thread and now I think I realize that I should probably be using SVG:

Chart format limitations Questions

I’m been using AppSheet for a while but am still pretty much of a novice in regard to charts so I need some help. I’m interested in doing something like this: [23] I know I can do it horizontally but, because people normally hold their phones vertically and also because it would be great if the user could scroll to take in a long image like this, I’d like to do it vertically. I’ve looked but, as far as I can tell, vertical orientation isn’t possible in AppSheet. Am I correct about that? C…

[Jonathon]

Hey Kirk,

Something like that would be possible, but there are some constraints:

• There is some limitation on vertical scaling of images / svg’s within AppSheet - at a certain point they get cropped
• Dynamically adding or removing bars on an axis may be difficult to achieve in AppSheet. If there is a static number of bars you wanted to display, that would work better.

Regarding the chart you showed, have you considered using a line chart?

Jon

[Kirk_Masden]

Thanks @Jonathon! Indeed, a line chart is a choice I looked at but after playing around with the textual approach, I’ve pretty much decided to go with that after all, especially since it seems easier and more practical for me than SVG. Here’s another little chart I made today (as a regular, new feature of my app):

① ⫿⫿⫿ 9 (<2s)
② ⫿⫿⫿⫿ 14 (2-6s)
③ ⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿ 42 (6-18s)
④ ⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿ 80 (18-60s)
⑤ ⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿ 135 (1-5m)
⑥ ⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿⫿ 56 (5-30m)
⑦ ⫿⫿⫿⫿⫿⫿⫿ 29 (0.5-2h)
⑧ ⫿⫿⫿⫿⫿⫿⫿⫿ 33 (2-8h)
⑨ ⫿⫿⫿⫿⫿⫿ 25 (8h-1.5d)
⑪ ⫿ 3 (1.5-3d)
⑫
⑬
⑭ ⫿ 1 (>15d

In addition to a visual representation of the number of instances in each category, I wanted to have plenty of room for labeling (number of instances followed by the period of time since previous instance). Since the labeling is pretty important, I think I’ll wind up sticking with this.

[Joe_Ojay]

Thanks for your input @Kirk_Masden and @Aleksi @Jonathon

I’m not sure what is meant by a fixed x-axis. The data is updated regularly so the values do change frequently, but generally speaking, the x-axis will change infrequently. Probably once once a month.

What I had in mind was something like this (see attached).

Alternatively, I know Appsheet accepts URL… Can I publish the chart I have in Google sheets and then simply have an image displayed in a dashboard fashion (large scale)? I know Appsheet supports URL but I’ve rarely seen URL’s being used for dynamic charts that are updated on the back end. Also, I’ve typically only seen apps that have URL links embedded in in-line views or thumbails, that you have to click to enlarge and visualize. I’m looking for a solution that enables the user to visualize the chart without clicking further, like a dashboard, as said above.

Thanks!

[Joe_Ojay]

Hello all,

so because of the limitations of the native charts in Appsheet, it seems that the following link explains how to add a link to a dynamic chart in google sheets, which could be a work around that would satisfy me.

Can you tell me if this feature (specifically the code pertaining to google sheet image) is still applicable because when I try the code it gives me an error.

help.appsheet.com

Displaying Images and Documents

How to display documents and images in your app.

@Kirk_Masden