Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a dataset that containts several values. How can I set a summary box on my dashboard that only shows the total amount for a specific value?
More concrete: I have invoices that should have a Tax code assigned to them. On the main page of my dashboard I want to have a table, graph... that always shows the number of invoices without a Tax code assigned. I can create a graph that plots all Tax Codes and there I see the number of invoices without one assigned but I would like to have a specific indicator on my main dashboard only showing those invoices.
I tried to do this by creating a statement in my expression:
count(if(TAX_CODE= '(Null)',1,0))
but this doesn't return the expected result. Is there any other way to do this?
Thanks in advance,
Kind regards,
Jens
Hello Jens,
I suggest using set analysis as follows:
Where you will use another field to count
Count({<TAX_Code={''}>}FieldToCount)
attach is an example.
Hope it helps,
Eliran