Set analysis - calculation with dates

[annanirvin]

Hi all.

Can someone please help me with this calculation?

=Num(NumericCount (DISTINCT {1<Ä_slag={'AEF'}, Substatus={'Inkomna'}, Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}Ärendeid) / Sum({<Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}P_AEF), '# ###%')

NumericCount (DISTINCT {1<Ä_slag={'AEF'}, Substatus={'Inkomna'}, Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}Ärendeid) gives the correct answer as well as Sum({<Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}P_AEF) but not when I combine them. I suppose the problem has to do with the Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"?

Best regards,

Anna

[sunny_talwar]

Where are you using this? Text box or a chart? What do you get individually and what do you get when you combine them?

[sasiparupudi1]

If you remove Num function, do you get the desired results?

[annanirvin]

I use it as text in chart in a gauge chart.

NumericCount (DISTINCT {1<Ä_slag={'AEF'}, Substatus={'Inkomna'}, Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}Ärendeid) gives '1' and Sum({<Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}P_AEF) gives '4' when used individually and the result should be 25%, but as you can see in the right chart above it gives 26,49%. Any idé of why and how to solve this?

[annanirvin]

No, it doesn´t work.

[Anil_Babu_Samineni]

Would you share sample to look

NumericCount (DISTINCT {1<Ä_slag={'AEF'}, Substatus={'Inkomna'}, Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}Ärendeid)

This will return only numeric numbers of Ärendeid where Filters are applying with Constant value like even if your selection is happening on filter pane it won't react.

I didn't known if there is any error on this. Seems ok to me

Sum({<Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}P_AEF)

This is also works for you, Try like below

Num(NumericCount (DISTINCT {1<Ä_slag={'AEF'}, Substatus={'Inkomna'}, Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}Ärendeid)/Sum({<Datum={"$(=Date(Max(Datum),'YYYY-MM-DD'))"}>}P_AEF),'#,#0%')

[annanirvin]

Unfortunately I can´t share since my work is confidential.

Thank you, but your solution gives 26,50%. Still not right that is.

[Anil_Babu_Samineni]

I've tried this?

=Num(1/4,'#,#0%') -- It is giving 25% in KPI. Can you check from your end

[sasiparupudi1]

I think there may be a rounding issue here.. your sum might be returning 3.77 andhence you see 26%..

[annanirvin]

That´s right but for some reason I doesn´t seem to get '1' and '4' in my combined calculation, only when I use them individually.