Reporting Charts I can't collect or show the text field? I need urgent help

Hello;

I'm preparing a report. I shared what I wanted with the graphics below. Please can someone help?

New Report - Page Name
Personnel Search Page - Search Section Table Name
Personnel Transaction Type Data - Name of the Table Where the Data is Stored

I want to graphically show in the report the actions taken by the user after the data he selected from the search section.

Example:
There are 4 personnel, these personnel can perform more than one operation, I want to show them separately on the main chart. But _rownumber always appears

BaลŸlฤฑksฤฑz-1.jpg

 

Ekran gรถrรผntรผsรผ 2024-01-25 121157.pngEkran gรถrรผntรผsรผ 2024-01-25 121203.pngEkran gรถrรผntรผsรผ 2024-01-25 121211.pngEkran gรถrรผntรผsรผ 2024-01-25 121219.pngEkran gรถrรผntรผsรผ 2024-01-25 121230.pngEkran gรถrรผntรผsรผ 2024-01-25 121247.pngEkran gรถrรผntรผsรผ 2024-01-25 121258.pngEkran gรถrรผntรผsรผ 2024-01-25 121305.png

https://www.appsheet.com/template/AppDef?appName=PazarlamaRaporu-44758332&appId=5bdff5ee-add7-464f-8...

 

@MultiTech 

0 6 266
6 REPLIES 6

For the chart, try selecting a different column than the rowNumber; maybe the Name?

  • It should be mentioned that getting the vanilla charts in AppSheet to play nicely is.... difficult.

If you need to control the chart more precisely, I suggest integrating QuickChart.io into things; this service allows you to create charts on the fly.  I've got a video that shows how to get started:

I tried, but the other fields do not appear because there is no number in the row series stack. I've done it a little bit, but when I select more than 2 staff, how can I organize the other fields for the 1st staff?

Staff: Samet ร–lmez There are 2 Marketin Reports in November There are 3 Collection Reports in November There are 4 Collection Reports in November Only if I select Samet ร–lmez in the Personnel Selection section, it gives the correct result. But it also gives the other personnel.

emreekincicanva_0-1706373439124.png

However, when I select all the personnel, the statistics of Samet ร–lmez and other personnel appear above and below the graph.

emreekincicanva_1-1706373482111.png

------

emreekincicanva_2-1706373499392.png

emreekincicanva_3-1706373526795.png

 

Is there anyone who can help me with this?

@MultiTech @AleksiAlkio @Denny774 @Suvrutt_Gurjar @Marc_Dillon @scott192  @WillowMobileSys @OptimiX_XcrY @Rafael_ANEIC-PY @Steve 

Please someone help.

Hi,

I'm not good with charts, I usually keep trying things until I end up changing the graph type or the data structure. 

If it's a small app with small data,perhaps create the graph in google sheets , and use a workaround like in this post ? :

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Place-the-Google-Sheet-Chart-onto-Appsheet-app/m...

I'm curious to take a look at your app, (I don't have access and don't know how to request it), but I can't promise anything.

In one if my apps with graphs, I gave up, and build it so I can only see one person at a time selected, seems similar to your case.

Thank you for your answer, unfortunately I don't think so. I'm trying to solve it using the table. If you can provide your e-mail address, I will give you private authorization for the application.

Top Labels in this Space