Conditional filter

[Anonymous]

Hi,

I've got a table with hourly information displayed in the rows.

In some period of the day, an intervention can be applied, and I have two scenarios: a what if run (as if the intervention didn't apply) and an outrun scenario (with the result of the intervention). As an example, consider the following table:

Hour	Unit	Target	Intervention
04:00	A	5	0
04:00	B	7	0
04:05	A	6	0
04:05	B	7	0
04:10	A	4	0
04:10	B	6	0
04:15	A	4	0
04:15	A	0	1
04:15	B	6	0
04:15	B	10	1
04:20	A	0	0
04:20	B	10	0

I need to analyze the information of the units (much more complex than the table above) during the whole day. When the intervention applies, I should consider the "1" scenario. How to cope with this? A simple filter would just delete the rows with "0", but I would lose the informations on the period with no intervention...

any help?

thanks!

[harshnathani]

@Anonymous ,

Can you let us know what is the expectd output.

Regards,

HN

[Anonymous]

@harshnathaniright, sorry!

Actually I was trying to work on the filters directly in the Report tab, but I guess that the easiest solution, or a more functional output could be a new table where in case of intervention the "0" scenario doesn't appear (it might be a problem if the table I'm working with is a 70MB and more?).

The final output is a graphical object where I display the targets of different types of unit during the day. Of course, if I have the two scenarios, the two effects are summed, If I have only one of them, some periods of the day aren't displayed (the ones where the intervention doesn't apply).

I hope is more clear...just tell!

thanks!

[Anonymous]

HI @Anonymous,

What type of calculated fields are you wanted? Measure or calculate column? If you mean calculated column, current it not able to integrate with slicer/filter to their selected value as filter conditions.

In addition, please share more detailed information to help us clarify your scenario.

How to Get Your Question Answered Quickly 
Regards,

Xiaoxin Sheng