Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Possible to Sort / Filter table?

Avatar

Level 8
Level 8

Hi there,

 

We created a table as following example, sorts Product Name by Order in the last day.

Just wanted to ask:

Is there a way to create (or filter) a table with number of Order greater than X that have Purchase% lower than Y (of the latest day)?

E.g. a table shows all Product Name those Order more than 20 AND Purchase% lower than 40% in 17-OCT (last day, latest day). - Keep all the past 7 days data.

 

H_L_0-1666150092148.png

 

Thanks in advance.

H

 

5 Replies

Avatar

Community Advisor

It's not easily done in Analysis Workspace. Unfortunately, in there, tables can only be filtered by dimensional values.

Segments won't work in your case because segments are applied on the individual hits of data. In your case, though, you want a total number of Orders or an aggregate percentage of Purchase% over a range of hits.

Your best bet is to build this in Excel.

Avatar

Level 8
Level 8

Thanks for reply, then we need to find a way to build the dynamic table, since the ideal table is: scheduled and delivered on daily basis, which means, everyday, build a table (report) with the last 7 day's data, sort by Order and include those Order > 20 and/or Purchase% < 40% in the last date.

Maybe we need to schedule the raw data, and ask DBA's support to proceed in another BI tool.

 

Have a good day.

Avatar

Community Advisor

If you have permission to use ReportBuilder (and are using a Windows computer with Excel), then you can build and schedule your reports in Excel using ReportBuilder to get the data for you. Then you don't need to go down the DB/BI tool path.

Avatar

Level 8
Level 8

Hi yuhuisg,

 

yes I am using report builder and scheduling the report, I am still thinking how to make it...could you provide some threads or ideas about the "filter" function can be refreshed on daily basis?