topic Re: exclude string set and date today set analysis in App Development

exclude string set and date today set analysis

joeybird — Mon, 16 Nov 2015 16:09:37 GMT

Hiya

I have a calculation - set analysis as follows

count({$< Department = {"Furniture"} >}Customer_No)

but my two tables have a string in my data load

e.g

dataload

'Daily' AS "DateType" .......Table 1

'Weekly' AS "DateType" .......Table 2

I need it only to count

count({$< Department = {"Furniture"}, DateType="{Daily"} >}Customer_No)

but I still have to on the filter pane DateType select the Daily, for the correct number to show

also I need to only include OrderDate Today(), weirdly in kpi on date shows 1899

please help

Re: exclude string set and date today set analysis

sunny_talwar — Mon, 16 Nov 2015 16:11:04 GMT

Your double quote seems to be out of order:

Try this:

=Count({$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"$(=Date(Today(), 'YourDateFieldFormat'))"}>}Customer_No)

Re: exclude string set and date today set analysis

Mark_Little — Tue, 17 Nov 2015 08:30:46 GMT

Hi,

Sunny's suggest should point you in the right directions. I might be mis-understanding, but are you using multiple calendars? This can cause issues if not set up correctly, The below document can help if that is the case.

Canonical Date

Mark

Re: exclude string set and date today set analysis

joeybird — Wed, 18 Nov 2015 19:18:07 GMT

this worked brill, but weird reason needed a today (1)

=Count({$<Department = {'Furniture'}, DateType = {'Daily'}, OrderDate = {"$(=Date(Today(1), 'YourDateFieldFormat'))"}>}Customer_No)

thanx team

Kind Regards

Re: exclude string set and date today set analysis

sunny_talwar — Wed, 18 Nov 2015 19:20:12 GMT

Never really understood the difference between Today() and Today(1) (and even seen Today(2)). But I am glad it finally worked.

Re: exclude string set and date today set analysis

joeybird — Wed, 18 Nov 2015 19:26:19 GMT

I have guessed .... you think its something to do with time zones? as uk, this works as today (1)

Re: exclude string set and date today set analysis

sunny_talwar — Wed, 18 Nov 2015 19:27:14 GMT

Could be. May be hic‌ can shed some light on this.