Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I'm creating a dashboard with a series of barcharts, each barchart showing the weekly evolution of a value for a specific project (i.e. one barchart per project).
These charts should only be displayed for the projects selected by the user (all projects are displayed if no project is filtered)
For my data, I have 3 fields : [ProjectName], [Week], and [MyValue].
I've tried the following formula :
=Sum({<ProjectName={$(=SubField(Concat(DISTINCT ProjectName, '|'), '|', 1))}>} MyValue)
But it doesn't work
I know that SubField(Concat(DISTINCT ProjectName, '|'), '|', 1) give me the first project and that I have data for this project: my barchart displays data if I change this formula by Sum({<ProjectName={'Name of the project'}>} [MyValue]))
How could I change my formula to make it work?
Try this
=Sum({<ProjectName = {"$(=SubField(Concat(DISTINCT ProjectName, '|'), '|', 1))"}>} MyValue)
Try this
=Sum({<ProjectName = {"$(=SubField(Concat(DISTINCT ProjectName, '|'), '|', 1))"}>} MyValue)
That works
Thanks a lot!
Oups, wrong button