Forum Discussion

butlerjay87's avatar
butlerjay87
Helper I
8 years ago

Creating a Flag from 2 Value-Columns

Hello,

 

I currently have a stacked bar chart with the following data. The chart currently sums the ED and MIU Attendances together and then stacks by Provider.

 

I have now been asked if we can filter by ED and MIU Attendances.

 

This is a snapshot of my data table (please note that I have about 10 other columns of data to contend with):

Provider         Date                    ED Attendances        MIU Attendances

ABC                17/07/2016          10                              5

DEF                17/07/2016           12                              9

GHI                17/07/2016           15                              5

ABC               24/07/2016           12                              4

DEF               24/07/2016            11                              6

GHI               24/07/2016            18                              5

 

I am looking to add a column that will flag ED and MIU so that I can then use a filter.

 

Any help is much appreciated. Thanks in advance

No RepliesBe the first to reply