topic Re: Sorting By Date in Visualization and Usability

Sorting By Date

OmarBenSalem — Thu, 20 Oct 2016 14:21:16 GMT

Hi Everyone,

Here is what I'm doing,

I've created an Inline Table :

Timeframe:

LOAD * INLINE [

TimeframeId, Timeframe

1, Monthly

2, Yearly

];

So my graphics will vary as I select a Frame,

For example, if I select Monthly, I will see the evolution of my KPI for the last 12 months, yearly is for the last 2 years evolution.

My dimension is as so :

pick(timeframeId,

month(calendar_date)&Year(calendar_date),

year(calendar_date)

.Now, if I select Monthly, I will have this grphic( the evolution for the last 12 months):

My selected Date is 19 of October.

You can see that the sorting is wrong since October2016 should be at the end !

What I haven't understood is, when I select a date in a completely charged month, for example 20 september 2016, I will have a sorted graphic !
I've tried so many expression to counter this and still can't find a way to correct it.

Can anyone help? Thanks !

Omar,

Re: Sorting By Date

sunny_talwar — Thu, 20 Oct 2016 14:24:20 GMT

I think you image isn't attached properly, can you reattach please?

Best,

Sunny

Re: Sorting By Date

OmarBenSalem — Thu, 20 Oct 2016 14:38:28 GMT

Re: Sorting By Date

rupamjyotidas — Thu, 20 Oct 2016 14:44:15 GMT

If the Dates are in NumberFormat. Usually Sorting can be done with this setting.

Re: Sorting By Date

Anonymous — Thu, 20 Oct 2016 14:44:52 GMT

Wouldn't it be easier if you created a cyclic group for your dimension instead of defining an inline table with time frames ?

Re: Sorting By Date

sunny_talwar — Thu, 20 Oct 2016 14:45:53 GMT

Are you using an expression for sorting? Like a Match() function expression? I think you need to use Match(Only({1} FieldName), .....) to not allow for it to drill down based on selections.

Re: Sorting By Date

rupamjyotidas — Thu, 20 Oct 2016 14:46:37 GMT

Oops I replied too soon. Instead of doing below in Dimension

month(calendar_date)&Year(calendar_date),

Why not in Script you do this

Date(Callendar-Date,'MMM-YYYY') as MonthYear

then you can sort is by the settings above

Re: Sorting By Date

OmarBenSalem — Thu, 20 Oct 2016 14:48:47 GMT

It's the client demand; he want a dynamic dashboard in which all the graphics will change as he select a timeframe

Re: Sorting By Date

sunny_talwar — Thu, 20 Oct 2016 14:49:14 GMT

Or use this as your dimension:

Pick(timeframeId,

MonthName(calendar_date),

Year(calendar_date))

Re: Sorting By Date

OmarBenSalem — Thu, 20 Oct 2016 14:55:44 GMT

That went reaaly good !

I've created a Month-Year field in my calendar; then changed my dimension as so :

pick(timeframeID,

date(MonthYear,'MMM/YYYY'),

year(calendardate)

)

then I sorted by ascending numeric value, and that went good !