Stimulsoft Business Intelligence System | Forum

Hello, I want a text box to display different messages based on the max value in a data source.

If this were my data source named Employees, what formula could I write such that "Sales" displayed in the text box given that it had the max value in Employee Count?
DEPARTMENT, EMPLOYEE COUNT
Sales, 205
Human Resources, 100
Customer Service, 97

Hello,

Please try to use the following expression:
{FirstIf(DataSource.DEPARTMENT, DataSource.COUNT== Totals.Max(DataSource.COUNT))}

Thank you.

Hello,

That doesn't seem to be working. The textbox prints as blank. I also noticed that even if I just do Totals.Max(DataSource.COUNT) I still get a blank text box.

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

For some reason, it's not letting me attach the dashboard file. But using the attached data file, the dashboard would contain a text box that had exactly this:
{"The department with the most employees is " + FirstIf(Sheet1.DEPARTMENT, Sheet1.EMPLOYEE_COUNT == Totals.Max(Sheet1.EMPLOYEE_COUNT))}

Hello,

Unfortunately, in dashboards, it is not possible.

Thank you.