Creating parameter

Q&A
, ,
1

Hi team, in my analysis or creation of dashboard I have used multiple datasets, each dataset having different date column, each date column is different from another dataset date column, it is not possible to use possible to use single or any dataset date column as a DataSource filter (single date filter for entire dashboard). So, I want to use parameter, but here my requirement is date part should be relative dates like current year, previous year, c. quarter, p. quarter, etc….

So team please help me to create a parameter like relative dates and how to use that parameter.

Thanks, in advanced.

Regards,

Chaitanyakumar N

2

Hi @Cnagabhairava,
Currently when working with date/time parameters, a date picker is the only available option unlike when you setup a control from a filter. Additionally, ‘Day’ is the largest time granularity you can currently achieve with a parameter.

I will mark this as a feature request to promote visibility to the AWS support team.

3

ok Brett thank you for your answer, I want to go like this

create parameter with text data type

then I want to create a calc filed called choose_datepart =

if date param=’year’ then year(today)

else if date param=’ previous year’ then datetrunc(‘year’,today())-1

elseif date param=’quarter’ then datetrunc(‘quarter’,today())

elseif date param=’previous quarter’ then datetrunc(‘quarter’, dateadd(‘day’,-1,datetrunc(‘quartrer’,today()))

elseif ‘none’

Brett, is it working, please help me to write correct calc

4

Hi @Cnagabhairava,

In that scenario, are you trying to use truncDate on a specific date field or different date fields? If different, are each of those different date fields located in the same dataset?

5

Hi @Cnagabhairava

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with archive this topic.

Thank you!

6

Hi @Cnagabhairava

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!

7

Thank you for your support Xclipse,

Yeah, if I have any doubts, I will ask in QS community.