Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Data model : I have only single table based on that have to create data model, that data model should show star schema.
Dashboard : in my dashboard shows weekly bar chart initially later on it should show detail bar chart like five days of in that particular week(this is the my dashboard)
please find the attached excel file for data.
Thanks in Advance,
Regards,
Munna
Write the load script this way
MainTable:
LOAD
[employee ID],
WeekDay([In Time]) as WeekDay,
[In Time],
[Out Time],
Flag
FROM
DATA.xlsx
(ooxml, embedded labels, table is Sheet1);
And on the UI
Dimension :- WeekDay
Expression:- =Count( {<Flag={'Y'}>} [employee ID])
Hi Anand,
I need Data model like star schema and dashboard.
Regards,
Munna
Then try to create separate Date Dimension table which connect with Key called employee ID] & '-' & [In Time] and contains date dimension Intime, Outtime, WeekDay etc.
MainTable:
LOAD
[employee ID] & '-' & Num([In Time]) as Key,
[In Time] as InTime,
[Out Time] as OutTime,
Flag
FROM
DATA.xlsx
(ooxml, embedded labels, table is Sheet1);
DateDimTables:
Load
[employee ID] & '-' & Num([In Time]) as Key,
InTime as [In Time],
OutTime as [Out Time],
WeekDay(InTime) as WeekDay,
Year(InTime) as YearField,
Month(InTime) as MonthField
Resident MainTable;
Drop Fields InTime,OutTime;