topic Re: How to filter by hour? in App Development

How to filter by hour?

valpassos — Sat, 16 Nov 2024 20:24:51 GMT

Hi community,

I need to filter my data by date and time, like this:
From 20-March-2018 10:30
To 27-April-2018 12:30

How should I build the Time dimension? Does it need to be in the Date dimension table?

Thanks,

Lisa

Re: How to filter by hour?

valpassos — Mon, 22 Jul 2019 08:55:57 GMT

Oh, and also, do I need to have 2 calendars to filter this way, From/To time periods?

Thanks in advance 🙂

Re: How to filter by hour?

shiveshsingh — Mon, 22 Jul 2019 08:57:26 GMT

Can you try this?

Timestamp( Field,'YYYY-MM-DD hh.mm')

Re: How to filter by hour?

valpassos — Mon, 22 Jul 2019 09:17:56 GMT

Hi @shiveshsingh ,

That's what I have right now, but that solution doesn't let me filter by time intervals, like >= 09/05/2019 12.00 <= 10/05/2019 13.00. This doesn't work.
Also, I should have a Time conformed dimension, no? Or should it be collapsed in the Date dimension?

Thanks,

Lisa

Re: How to filter by hour?

shiveshsingh — Tue, 23 Jul 2019 05:33:48 GMT

Hi Lisa

You can have time embedded dimension in Model itself, and then modify it while using in expressions.

Thanks

Re: How to filter by hour?

mahaveerbiraj — Tue, 23 Jul 2019 06:30:55 GMT

Hi ,

you can create two inline table with each one column call StartDate =(Timestamp( YourDateField,'YYYY-MM-DD hh.mm') ) and EndDate =(Timestamp( YourDateField,'YYYY-MM-DD hh.mm') ) ,Create filter pane for both StartDate And EndDate

and then Store the selected value in Variable call vStartDate= GetFieldSelections(StartDate ) and

vEndDate=GetFieldSelections(EndDate ) and use those variable in SetAnalysis like below:

Sum({<YourDateField={"<=$(=vEndDate)>=$(=vStartDate)"}>} TXN_AMOUNT)

Let me know if your not clear with this work around........