Individual Day Wise Data Extraction

munnawar — Wed, 25 Nov 2020 16:16:04 GMT

HI Friends,

I have table in which data is storing Day wise , I want to extract these day wise field n create a single Coloumn ,

So that i can relate to my Master Calendar day wise and Extract Day wise data in my Charts

Re: Individual Day Wise Data Extraction

pedrobergo — Fri, 08 Dec 2017 08:47:45 GMT

Hi Munnamwar,

Just join the table WiseDaysTable with the MasterCalendar. You just need load the WiseDateTable using the same Data name field.

Load Data (same field as Master Calendar)

1 AS WiseData

FROM (...);

So you can use in Set Analysis to exclude the wise days.

SUM({$<WiseData-={1}>} fieldname)

or include these days

SUM({$<WiseData={1}>} fieldname)

[]

Pedro