topic Re: Set Analysis - Greater than other field in chart table in App Development

Set Analysis - Greater than other field in chart table

Anonymous — Wed, 21 Apr 2021 15:06:44 GMT

Hi,

to simplify, i have 3 tables:

table1 (Facts):

FactsId	Date	Time	Revenue
12345	2021-04-20	17:38:56	13.44

table2 (Calendar):

Date	Weekday
2021-04-20	Tuesday

table3 (Event-Meta-Data)

Weekday	Name	From	To
Tuesday	Event No. 1	17:00:00	18:00:00

My chart table should look like:

Name	From	To	Revenue	Weekday
Event No. 1	17:00:00	18:00:00	13.44	Tuesday

Ive set a filter on the specific Date.

I want to solve it with Set Analysis, but with no result so far.

pseudocode: sum({<Time = {"> From < To"}>} Revenue) ??

How can I do it?

Anonymous — Wed, 21 Apr 2021 15:06:11 GMT

I think i solved it myself with the following syntax:

FactsId = {"=Time > From","=Time < To"}

Do you see any errors in there?

Thanks alot!

duchezbr — Wed, 21 Apr 2021 16:06:32 GMT

This will aggregate revenue with hardcoded [From] and [To] values:

Sum({<Time = {">17:00:00"}> * <Time= {"<18:00:00"}>}Revenue)