Pyramid Chart

Ask for Help
21

Do you have a fixed list of actions?

If yes, I would create a separate table that just lists the unique actions, one on each row.
Then add your relation and rollup columns in that table.
That should give you one row per action, with a count for each, which you can feed into your template.

If your list of actions is dynamic, then it’s still possible, but a little more complicated.

22

This spreadsheet represents services, there is various information stored in this table, we can consider this table as action tables, and it is actually quite complex because many columns are reused in various ways in various different places, this column in particular records the name of the action , has columns such as who did the action, when they did it, among other data, and I need to create a quantitative analysis of each action by the name of the action performed

23

Yes okay, but you appear to have ignored my question.

The answer to this question will determine the best approach.
If the answer is yes, then you can use the approach I suggested:

But if the answer is no, then you will need a different approach, which I can help you with. But I don’t want to waste my time describing the second approach if it isn’t required.

24

Sorry, I forgot to answer this, well the actions are:
Service
Scheduled visit
Proposal
Closure
Receipt
Received
Filed

25

Okay, good. That makes it easy :slight_smile:

Here is what you should do:

  • Create a new table, and add a column for the action name
  • List the actions in that column, one per row
  • Now add the multiple relation column that matches the action name with the action name in your other table.
  • Now add a rollup column, that targets the multiple relation column and does a count. This should give you a count for each action.
  • Now add a template column. The template column should output just one “layer” of your pyramid chart on each row, using replacements for each of the action name and action count
  • Finally, create a Joined List column that targets your template column. By default, the joined list will use a comma as a separator. You should delete that and use an empty separator, otherwise it will break your HTML.
  • That joined list column can be used in a Rich Text component to display your chart.
1 Like
26

I would like to not need to create a new table, and there are many steps that I don’t know if it would work, the funnel was complex html, I wish it was just a template column to point to the rich text component, before trying this , wouldn’t it be simpler for me to create a joined list column with the action name column, then create a javascript column where I count the number of occurrences of an action name and it returns the total sum of times the name of an action appears? Since p1 would be the joined list and p2 would be the name of the action that I want the javascript code to analyze to count how many times it finds the name passed in p2?

27

It’s your App, so you can do it any way you like :man_shrugging:

The method I gave you will work, if you follow the steps correctly. But if you prefer to do it some other way, then by all means go ahead. And yes, you could certainly get the same result with a JavaScript column. But I wouldn’t consider that any simpler.

2 Likes
28

I decided to follow my heart and I chose a solution with javascript, thanks a lot for the all knowledge shared with me and lot thanks all, this was the hardest task that I made in a glide in my journey when I started using glide

Captura de Tela 2023-12-22 às 15.17.14
Captura de Tela 2023-12-22 às 15.17.14860×611 41 KB

3 Likes
29

I have a big change to make and I’m stuck on the solution, can I reactivate this topic?

30

If it’s related, then yes by all means.

But if it’s related to something else, then better to create a new topic.

31

It’s about the graph but it’s changing the values of the graph based on a choicer, I need to change the joined list responsible for listing the actions, currently it lists all actions by everyone, I need to create a filter of actions by people, based on the name of the person selected in chooser, or another solution for this

32

That should be easy enough:

  • Capture the User selection in a User Specific column
  • Use a Query column to target your data table, and filter by the selected user
  • Get your Joined Lists via the Query column
33

yes, I had thought in some like that, but I don’t know where I started to make this work.

I needed to make a filter, and I needed to make a way to columns javascript looking for the same columns, but the data changed based on the column that choices add new value based on the choice of the user, to make the choicer add on some column that the name that is selected is pretty easy, but I don’t have any idea that kind of logic I need to make on another column to change your values based on this and how i use on Javascript column that i has make

34

in this pic, we can see two kinds of joined lists, in left we can see the joined list that lists actions per user, and on the right of the picture we can see all of the actions applied for all users, In column left side I want to use based on some specify column that I put selected name of the user on choicer that list usernames, in this example I guess that chart change values base on a selected name, this change is very complexity for me

açoes joined list
açoes joined list1030×787 181 KB

35

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.