Hide Chart if less than two rows in query

Wappler General How To
,
#1

Hi,

I want to only show a chart if my data view includes at least two rows as otherwise, the line chart does not make sense with only one value.

I added a dynamic attribute of hide to the chart and tried to enter the when condition as shown in the screenshot. Unfortunately, the chart is still shown when there are none or only one row in the data view. What did I do wrong?

hide chart
hide chart641×1124 50.4 KB

Thank you very much. I appreciate your help.

Have a good weekend!

#2

Hi.
Can you please check the CODE tab and post what it contains?
In the above screenshot, when you close the top-most popup, the pop-up behind should have this tab at the bottom - design & code.
It could be that the picker is generating some incorrect code.

1 Like
#3

Hi @sid it states:

(data_view1.data.count() < 2)

Thanks!

#4

This looks fine. I haven’t worked with data views much. So could be something to do with that.
But the expression is correct & your logic too.

#5

Thank you, I used the data view as the chart was showing the x-axis in the wrong order. I use dates on it so I thought the data view would be a workaround as I need the original order of the query for my repeated table. Maybe someone else has an idea.

#6

I think what you are looking for is:

data_view1.items < 2
1 Like
#7

Thank you for your suggestion, @mebeingken I tried this also on the original query but sadly it did not work.

I use the hide attribute; would it make sense to use show instead? But then I think I would have to hide the chart with some other setting.

#8

@struppihh Just for testing purposes, are you able to display the number of items detected from your dataview?
Maybe it’s just not able to count the real number.

1 Like
#9

Dear all,

@ChristopheA I created a text input field and set the value to data_view1.items, and it showed the correct amount of items. I changed the name of the data_view1 to data_view_risk_score to make the name more speaking.

With some playing around, I found a solution that worked. Maybe it is not the best solution, but it is sufficient for me. I nested the chart in a display block element and added a dynamic attribute of show with the condition suggested by @mebeingken modified with the new data view name (data_view_risk_score.items > 1)

It works now fine, and the chart is showing up dynamically when a second risk score is added in the database without the requirement to reload the page.

Thank you, everyone, for your help!

3 Likes