Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bit of background...
I have a set of data that included 4 fields that indicate if data has been modified in the table. I want to be able to chart five different buckets: No mods made, 1 mod made, 2 mods made, 3 mods made, and 4 mods made. I don't necessarily care to indicate WHICH field was modified, just the number of the fields that were modified. Is there a way to accomplish this?
Thanks!
Assuming that your 4 fields are 1/0 flags, when 1 signifies a change, I'd recommend creating a calculated dimension as a summary of all 4 fields:
RANGESUM(Fld1, Fld2, Fld3, Fld4, Fld5)
In the expression, simply count the unique keys that identify your data:
count(distinct UniqueID)
This should do what you described...
cheers,
Oleg
You could evaluate the 4 fields in the load script and assign a 0-4 in a new count field. Could then sum up this new field in the chart - and also do the grouping.
What are the possible values of the modified? field? Yes/No, 1/0, Modified/Null()??
Assuming that your 4 fields are 1/0 flags, when 1 signifies a change, I'd recommend creating a calculated dimension as a summary of all 4 fields:
RANGESUM(Fld1, Fld2, Fld3, Fld4, Fld5)
In the expression, simply count the unique keys that identify your data:
count(distinct UniqueID)
This should do what you described...
cheers,
Oleg
This did the trick, well mostly. My fields weren't 1/0 flags, so instead of RANGESUM(Fld1, fld2, fld3, fld4) I used RANGESUM(if(fld1='None', 0, 1), ...)
Thanks!