Set Analysis - Greater than other field in chart table

[Anonymous]

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 · Accepted solution]

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]

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

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