every time I ask for weekly trend of sale in April, I only want to see the line chart, but it always sum all the number up to get the “total sale” which is not I want, since monthly total sales cannot be summed up that way. So I want to remove that part.
Hello Aivlys,
I think it also depends on your prompt question. Nevertheless, you can always edit the visuals to aggregate to weekly rather than monthly.
In addition you may also leverage custom instruction. refer - Creating a dynamic Year over Year Measure in Topic Q - #2 by Deep
Hope this gives some idea.
Cheers,
Deep
thank you! how to “edit the visuals to aggregate to weekly rather than monthly”? I can ony change the graph type for the output, but that is also not I want. I also write in custom instruction:"when user asks about “weekly” , always show “weekly trend”, and do not sum them up to get monthly " but still cannot work
Hi @aivlys,
It’s been awhile since last communication took place on this thread; did you have any additional questions or were you able to find a work around for your case?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @aivlys,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you