Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have values in my field Level as below.
Level
Sev 1
Sev 2
Sev 3
Sev 4
Now i want to group the values sev1, sev2, sev3 as priority 1 and sev4 as priority 2.
Atlast i want to display the listbox as priority
Priority
Priority 1
Priority 2
So that we can get the data by priority level on dashboard.
Can anyone please advice on this?
Thanks in advance!
Raju
This is the script that I used. I am still seeing the app (sample) that I attached.
Level:
LOAD * INLINE [
Level
Sev1
Sev2
Sev3
Sev4
Sev1
Sev3
Sev1
Sev4
Sev3
Sev2
];
Load *,
if(Match(Level,'Sev1','Sev2','Sev3'),'Priority1', 'Priority2') as Priority
Resident Level;
You can create another column 'Priority' in script where if the level is Sev1 to Sev3 then assign it a value Priority 1 and if the level is Sev4 then Priority 2. Create a list box using new field Priority.
Hope this helps. Let me know if you have nay questions.
Thanks for response Rajan! Can you please provide me in detail script.
Please find the sample qvw attached. I created a sample table that has only one coulmn Level and then added another column Priority.
load
Level,
pick(match(Level, 'Sev 1', 'Sev 2', 'Sev 3', 'Sev 4'), 'Priority1', 'Priority1', 'Priority1', 'Priority2') as Priority;
load * inline [
Level
Sev 1
Sev 2
Sev 3
Sev 4
];
Attachment not found in your response! If possible provide me screenshot.
That would be very helpful! Waiting for reply!
Thanks,
Raju
This is the script that I used. I am still seeing the app (sample) that I attached.
Level:
LOAD * INLINE [
Level
Sev1
Sev2
Sev3
Sev4
Sev1
Sev3
Sev1
Sev4
Sev3
Sev2
];
Load *,
if(Match(Level,'Sev1','Sev2','Sev3'),'Priority1', 'Priority2') as Priority
Resident Level;
Super Rajan! Its Working I spent lot of time on this!
Thanks for your support!
Thanks for your inputs! Working!
Hey Raju...If you find that answer is helpful or correct could you mark the answer likewise and close the thread. Thanks