Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
how to sort data month wise(Apr -> Mar) comparison in bellow attached dashboard kindly suggest...
when defining the months use the dual function.
Set Apr as 1
Mar as 2 etc.
Check this app
Take a look at your "table viewer". You have synthetic keys in your dashboard.
For User requirement we use synthetic key.but when Sorting in given chart its not working for me. please resolve
there is no such thing like synthetic key for user requirement. You need to correct your data model
Dear ioannis,
We want to need solution for this data model please help and suggest..
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 :