Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am currently working on a KPI dashboard using data extracted directly from SAP.
The issue I am having is although it is great to be able to access all of my required data in pretty much one file, I have so much data, I now need to seriously restrict the data that is being used.
Further on this, I also need to be able to have different restrictions in different charts within the same application.....interesting.
Example:
Source data has 170,000 lines, I only want the orders that were created 2016-Onwards, therefore what expression would I require to add to the 'CREATION DATE' column would be?
Source data has 170,000 lines, I only want lines that have a certain order type specified in the 'ORDER TYPE' column, and this is "EXAMPLE", what expression would I use to only see 'EXAMPLE' order types?
Thank you
try something similar
1:In the script write something like
where "CREATION DATE' >='01-01-2016' check your date format
else use similar thing using set analysis
2: If(MATCH([ORDER TYPE],'example'),[ODRER TYPE],NULL()) in the expression
Have a look at some Set Analysis resources:
try something similar
1:In the script write something like
where "CREATION DATE' >='01-01-2016' check your date format
else use similar thing using set analysis
2: If(MATCH([ORDER TYPE],'example'),[ODRER TYPE],NULL()) in the expression
Hi Pradosh,
Thank you very much this has worked with a little bit of tweaking to match the formats I have!
Best regards,
Alex.