sonysree88
Creator II
2019-01-22
03:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Percentage by Column by Dimension
Hi All,
I have 1 filed that have number ofrecords for example.1000 recs
I need 26th of percentage of all the records.
how to get this.Please provide solution asap.
Regards,
Sunitha
511 Views
2 Replies
MohammedMustaq
Partner - Creator
2019-01-22
03:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
In general 1000*26/100=260 Records
Try
But if you need to write in Expression!
=Count(recs)*26/100.
=Count([Field Name])*26/100
Thanks
Mustaq
In general 1000*26/100=260 Records
Try
But if you need to write in Expression!
=Count(recs)*26/100.
=Count([Field Name])*26/100
Thanks
Mustaq
506 Views
LVillage
Partner - Contributor II
2019-01-23
01:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,sonysree88
How about the following method?
1.Assign row numbers in the load script.
====<example:load script>=====
LOAD
rowno() as row,
Field1
FROM
…
;
2.Create a flag to determine the top 26%.(1:Top 26% 0:other)
====<example:Listbox Formula>=====
=if(row > round(max(total row)*0.26),0,1)
3.If you select "1" in the list box, you will be able to get 26% of records
Thanks.
470 Views