Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My Data is already in the format I want it, using Excel and SQl scripting.
How do I create a chart expression, that simply reads the existing data without any additional sums etc.
I also want to add some modifiers to this expression,
i.e. =(Data) Where School = School A
Thanks in advance
sum({< School = {'School A'} >} YourValue)
Thanks, however I don’t want to Sum
The data I have loaded in has already been summed, I simply want to display it, but with an additional filter built into the expression.
if( School = 'School A', YourValue)
What chart you using?
Let's say you use a straight table, you can just create a expression in the definition, just put a random number say 1 and then in presentation, you can hide that column,
Hope it helps.
If you don't want to use the sum function you can use the only function or, use the field in an IF function (it uses an implicit Only function)
=only($<School={'School A'}>} Value)
If, for any reason you have more than one value for School A, the function returns a null value.
Eduardo