Number Box Filter

[tbagby]

Hi -

I am trying to set up a number box filter using a range (min / max of existing column value). Possibly I am doing something wrong but I am getting a range of 0 to 0 even though I've entered an expression to default initial value to minimum and maximum of the "checking" column. When it loads (preview), the 0 to 0 results in no data loading. Can you assist in what I might be doing wrong? Screenshot attached. Thank you!

Number Box Filter Screenshots.pdf

(133.09 KiB) Downloaded 656 times

[Lech Kulikowski]

Hello,

Unfortunately, it is not possible to use Min/Max functions in the NumberBox expressions. You can add DataTransformation where calculate Min/Max and then use these columns in the NumberBox.

Thank you.

[tbagby]

Thanks Lech! I'll try that strategy.

[tbagby]

The Min / Max worked by using data transformation so all of my data loaded fine on initial load. As soon as I updated the range though, the associated gauges all lost their original filter settings. This was on my large data set from SQL. I saw in the documentation that the number box filter must be the exclusive filter, so I duplicated a dashboard page using only the number box and one chart and same result. I tested on a different test dashboard that used a CSV as data source and it works fine. Any thoughts on why it won't work with a SQL connection?

I do have an alternative of adding a table to the page and using the number filter within the header of the table to filter numbers across the dashboard. No problems there on SQL or otherwise.

Thanks again.

[Lech Kulikowski]

Hello,

Could you prepare a sample report that reproduces the issue and send us for analysis?

Thank you.

[tbagby]

Hi Lech - sorry for the delayed follow-up. I don't have a way to get you the report without exposing the SQL credentials. The scenario does work fine with a file-based connection (like CSV or Excel), so that wouldn't help you. We can set up a screenshare call if you like?

[Lech Kulikowski]

Hello,

Please send us your request with detailed description on support@stimulsoft.com.

Thank you.