Sorting Month Name Wise

[vijayit43]

Dear All,

              how to sort data month wise(Apr -> Mar) comparison in bellow attached dashboard kindly suggest...

[giakoum]

when defining the months use the dual function.

Set Apr as 1

Mar as 2 etc.

[anbu1984]

Check this app

[jsanchezh]

Take a look at your "table viewer". You have synthetic keys in your dashboard.

[vijayit43]

For User requirement we use synthetic key.but when Sorting in given chart its not working for me. please resolve

[giakoum]

there is no such thing like synthetic key for user requirement. You need to correct your data model

[vijayit43]

Dear ioannis,

                    We want to need solution for this data model please help and suggest..

[giakoum]

Your model is a bit of a mess.

1. inlfed-2 is useless, must be dropped

2. Quater in INLFED exists already in your main table as Quarter, so should be dropped. If you need the Q in front (Q1, Q2 etc.) add it in the main table

3. FY should be moved to the sales table as well

If you do the above, no synthetic key will exist

You have many calendar fields in the sales table and in other tables. Consider creating a normal calendar. there are many useful scripts in the community for that :

Understanding the Master Calendar (video)