topic Re: Colored bars in a table in App Development

Colored bars in a table

sgrobben — Thu, 19 Jan 2023 11:18:22 GMT

I have a table with admission periods (see attachment).

The [Admission period current admission (days)] is the following dimension:

ProcessingTime

The [Admission period last admission (days)] is the following dimension:

ProcessingTimeLastAdmission

The [Total admission period (days)] is calculated as follows:

Max(ProcessingTime) + If(IsNull(Max(ProcessingTimeLastAdmission)),0,Max(ProcessingTimeLastAdmission))

The bar graph in the table is the [Total admission period] in days and is created as follows:

Repeat('▇' , Max(ProcessingTime) + If(IsNull(Max(ProcessingTimeLastAdmission)),0,Max(ProcessingTimeLastAdmission)) )

So far, so great! Now i want to give the cubes who are from the last admission period a different color. For example, if the admission period from the current admission is 4 days and the admission period from the last admission is 1 day, i want 1 red cube and 4 green cubes.

How do i do this?

Thanks in advance!

Re: Colored bars in a table

KGalloway — Fri, 20 Jan 2023 21:06:26 GMT

Would something like the following work?

=repeat('🟩', max(B)) & repeat('🟥', coalesce(max(C), 0))

Also, I think the coalesce function will work better for your if statement. It returns the first non-null argument.

Re: Colored bars in a table

sgrobben — Mon, 23 Jan 2023 12:29:46 GMT

Hi, KGalloway,

The coalesce function works perfectly for the non-null values. I inserted your code in the [Expression] field. I guess that i also have to insert something in the [Expression text color] field to make the colors visible, right?

If so, what code did you insert here to make the difference between the red and the green color?

Thanks in advance!

Re: Colored bars in a table

KGalloway — Mon, 23 Jan 2023 14:07:33 GMT

I used =repeat('🟩', max(B)) & repeat('🟥', coalesce(max(C), 0)) in the [Expression] field. I did copy the green and red square characters from unicode sources I found through google. I didn't have to insert anything in the [Expression text color] field.

Re: Colored bars in a table

mikaelsc — Mon, 23 Jan 2023 14:44:45 GMT

emoji's are your friends 🙂

https://emojipedia.org/search/?q=square

Re: Colored bars in a table

sgrobben — Mon, 23 Jan 2023 14:53:19 GMT

Thanks!