as a newbe I have a question you sure can answer. I got a view to a database that gives me a set of assets, the installed software Firefox, Notepad++ and 7zip and the respective versions of that tools. My task is to build one page showing three charts, one for every software and versions. But only if the version is old.
I created a script, got access to the database and got every single field. I also created three variables (e.g. ZipVersion) with the wanted software versions of the three tools. But I can't find where I can limit the records for each chart on the specific software and furthermore the relevant version.
A conditional setting at the expression (Count(Assetname)) like this if(Software Like '7-Zip%' and SW_Version <> 'ZipVersion',Assetname) at Expressions has no effect.
Maybe it is very easy but unfortunately I don't see it.