Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I want the correct expression containing the AGGR Function for the given query.
Tried a few things but it didn't work out.
I'm posting the example below.
Sum[Count( Distinct (mobilecode))/Count(Distinct (routecode))]
Where mobilecode and routecode are field names.
Thanks In Advance.
It's upto where exactly you are using it !
Can you provide some more information on it?
Where you are using this expression?
If possible, provide sample data.
As I mentioned the answer depends on the context. What do you want to show and where do you want to show it?
In a KPI a single number or in a table with multiple rows?
Yes you can in certain situations get the calculation without using Aggr. You can do it if the inner aggregation use the TOTAL qualifier alone.
Gives us some sample data and an explanation on what you want to see ....