Creating reports and dashboards | Stimulsoft community forum

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!

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.

Thanks Lech! I'll try that strategy.

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.

Hello,

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

Thank you.

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?

Hello,

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

Thank you.