Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have a simple requirement to sort my dimension .
But no permutation or combination is working.Can you please help me out?
I want my time dimension in x axis to be sorted in 15 mins interval i.e starting with 6:00:00 PM.
Do i need to achieve with expression coz sorting it numerically in ascending or descending order is not working.
AD
Sample Data?
like u can refer to my screen shots..if that helps?
can you help me to come up any sorting by expression technique?
Ok, I'll try to create my own.
Update:
I tried with my data but it comes me in sequence unlike yours. Again the sorting will change from data to data and all I see is a Line chart and that's not really helpful.
Provide a sample data which reflects the data you've. Not raw data, just dummy data.
Can you add a screenshot of the sorting section of the edit screen.
i do appreciate for the effort Aehman..
So is toggle dimension your date field?
I am using aggr funtion in my measure expression where i qm including the 1st dimension of the toggle dimesnion I have created i.e Hour_link...the other 2 dimenions in my toggle dimension are timestamp_15 and timestamp_5..for 15 min and 5 min interval which I am creating through a master calender script
measure def:
if (SELECTOR1='CUM',
(RangeSum(Above(Sum(Aggr(Count({$<ALERT_PROC_STATUS= {'SUCCESS'},ALERT_DIRECTION={'I'},SERVER_NAME={'Axway_DEV'}>}CORE_ID),Hour_link)),0,RowNo()))+
RangeSum(Above(Sum(Aggr(Count({$<PROTOCOL = {'SAPALE'},ALERT_DIRECTION={'I'},PROTOCOL_INFO = {'TID=*'}>}ALERT_OUT_WFID),Hour_link)),0,RowNo()))),
(Sum(Aggr(Count({$<ALERT_PROC_STATUS = {'SUCCESS'},ALERT_DIRECTION={'I'},SERVER_NAME={'Axway_DEV'}>}CORE_ID),Hour_link))+
Sum(Aggr(Count({$<PROTOCOL = {'SAPALE'},ALERT_DIRECTION={'I'},PROTOCOL_INFO = {'TID=*'}>}ALERT_OUT_WFID),Hour_link))))
yes Bella...
Ok it looked to me like it was sorting by the measure not the axis but as that is not the case sorry I don't have any other ideas.