About KarunaTiwari

KarunaTiwari · ‎05-04-2018

Thanks for your reply Erik!!

KarunaTiwari · ‎05-04-2018

Hi all, I am creating similar kinds (not same) of Reports for 5 different Geographies. What will be better in terms of Report Performance- Creating One table in EG for all the Geos and filtering the data in Reports or Creating 5 different tables and using them in 5 Reports?? PS - The data is huge for all the Geos and the Reports are taking considerable amount of time in Opening. Thanks in advance, Karuna Tiwari

KarunaTiwari · ‎03-26-2018

Hi All, I have 2 columns in my data set - Handle Time and Handled Calls. I am creating an aggregated measure in the front end - AHT = Handle Time / Handle Calls. Now I want to create Buckets based on Aggregated measure AHT such as If AHT between 0 and 300, 'AHT Bucket'n = '0-300' Else If AHT between 300 and 600, 'AHT Bucket'n = '300-600' Else If AHT between 600 and 900, 'AHT Bucket'n = '600-900' Else 'AHT Bucket'n = '900+' Please can anyone help me with how to achieve this. Regards, Karuna

KarunaTiwari · ‎02-06-2018

Hi All, I have three dropdowns for Year, Quarter and Month in a Report. I have created a cascaded prompt from Year to Quarter to Month such that when I select an year , corresponding quarter is filtered and when i select the Quarter , corresponding months are filtered. Now I have the below 2 requirements: 1. First I select an year , then quarter and then month. Now if I clear the year , quarter and month dropdowns should also be cleared. 2. If I have not selected year or quarter, i should not be able to select month also. Thanks in advance, Karuna

KarunaTiwari · ‎10-13-2017

Hi @mariusg, I have a similar requirement of embedding a SAS VA report into a custom application. I also used an iframe but the problem is -it is again asking for username and password to login. I am aware that to achieve this we can use Guest access. We have a User webanon but that is not working. How to configure guest access? Thanks in advance!!

KarunaTiwari · ‎09-27-2017

@FredrikE Thanks a ton for your prompt reply. I will check the SAS Admin guide.

KarunaTiwari · ‎09-27-2017

Hi all, I have some confidential finance data. I am developing a dashboard based on that data. I dont want other developers (Operations, HR, Sales) to see my data or reports that I am creating. How can this be achieved in SAS VA? I am aware of row level security in SAS VA, but is there anything at User Level? Rgds, Karuna

KarunaTiwari · ‎08-24-2017

@itchyeyeballsThanks a ton for your time and patience!!

KarunaTiwari · ‎08-24-2017

@itchyeyeballs Thanks a ton for your time. Please find attached the dummy data and the graph (Both in Excel).

KarunaTiwari · ‎08-23-2017

@itchyeyeballs No Business Verticals is a categorical field and I want to show frequency of Business Verticals based on GEO.

KarunaTiwari · ‎08-23-2017

@itchyeyeballs If I put my two calculated fields into the measures section of the visual, then it will show me the frequency of these two calculate fields but I want to show the frequency of Business Verticals based on these calculated fields (Number of Business Verticals in India vs number of Business vertiacls Overall) Basically I want to use them as categories.

KarunaTiwari · ‎08-23-2017

Hi @itchyeyeballs, I have two columns in my data GEO and Business Verticals. The GEO field contains - India, UK, USA, etc I want to create a barchart showing the Distribution of Business verticals in India vs all the countries(including India). I tried to create two calculated items - Geo_India which is equal to 1 when GEO = India; otherwise 0 Geo_Overall which is equal to 1 when GEO in (India, UK, USA); otherwise 1 then was trying to convert these 2 measures to category to be used in the bar chart. but did not get what i wanted to achieve. Other option that I tried earlier was to create a custom category with the help of GEO field. But then I am not able to put India under both the labels - India and Overall. Thanks for your help.

KarunaTiwari · ‎08-23-2017

@itchyeyeballs Thanks for your reply. I tried creating calculated fields as suggested by you but that did not work. I want a bar chart like below:

KarunaTiwari · ‎08-23-2017

@collinelliot No Problem.. Thanks for you reply.

KarunaTiwari · ‎08-22-2017

Hi All, I have a Category field GEO which has values like India, USA and UK. Now I want to show the revenues of India vs Overall in a bar chart. I am able to create custom category -India(India) and Others (UK, USA). But I want to create custom categories - India(India) and Overall (India, UK, USA). How can I achieve that? Thanks in advance!!

Online Status	Offline
Date Last Visited	‎11-21-2019 06:23 AM

Row Level Security for Comments in SAS VA

Login duration of Users

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Report Performance

Re: User Level Security

Re: How to create a new custom category which has mutual data items?

Re: Creating datasets on the fly - SAS VA

Creating datasets on the fly - SAS VA

Re: Report Performance

Report Performance

How to bucketise aggregated measure in SAS VA?

Cascading prompts

Re: Executing a VA Report from an Application

Re: User Level Security

User Level Security

Re: How to create a new custom category which has mutual data items?

Re: How to create a new custom category which has mutual data items?

Re: How to create a new custom category which has mutual data items?

Re: How to create a new custom category which has mutual data items?

Re: How to create a new custom category which has mutual data items?

Re: How to create a new custom category which has mutual data items?

Re: How to create a new custom category which has mutual data items?

How to create a new custom category which has mutual data items?