Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me please.
i am trying to generate a graph in qlilview that shows the last 14 days with of data on a daily basis (ie there will be 1 bar for each day for the last 14 days)
please could someone help me the the correct set analysis expression to write
Two things which I was able to notice in the screenshots you shared
SET DateFormat='D/M/YYYY';
Anyway, try
=Sum({$<[Full Name]={'Darren Keirl','Chris Phillips','Gemma Young','Micheal
Heaney','Ginnie Brunning','Terry Crampton','Lisa Lewer','Emma
Hares','Julita Wakefield','Liz Halliwell','Sandra Searle'},
Date={">=$(=Date(Date#(Max(Date), 'DD/MM/YYYY')-14), 'DD/MM/YYYY')<=$(=Date( Date#(Max(Date), 'DD/MM/YYYY'),'DD/MM/YYYY'))"} >}
[TotalExternalInboundAnswered]+[TotalExternalInboundAnswered])
Hi
Thanks for the latest suggestion.
I have made th changes to the expression and still getting more than the last 14 days worth of data (pictures attached).
Regarding date format though, I only thing I can find in the Chart properties that relates to Date format is on the number tab however I can only change the number format for the Y axis -data I am trying to display (Total Calls), not the the x-axis-days/date etc. Can you guide me?
It would likely be most helpful for you to attach the QVW file, so folks can see the data model and chart with expressions etc., not sure they are going to be able to help further without that. If you have sensitive data, you can use the Scrambling tab in the Document Properties to scramble any sensitive field data.
Regards,
Brett
Hi Brett
My thanks for your advise. I am having some issues saving the QVW file and attaching it to this thread. I also cannot find the scramble option in the document.
Have you got any instruction that I could follow to help me?
Check the following Help Link:
The Community Article link as well:
Regards,
Brett