Hi guys need some help.
I made a slice of my data to filter the view to show only today’s date. I have a [date] column. This works fine.
However I made a chart as below which will show the entries for each column. These different coloured bars represent different [stores] however in the legend its displaying them as dates and not stores. How can I fix this ?
To be clear the slice filter formula I’m using is [date]=today() I want the blue and red legend to be the respective store ie. Blue should be Melb. Central and red should be Collins St.