Forum Discussion
Two data granularities overlayed
Hi JasperVanGils ,
This doesn't make sense, in the Line and clustered column chart, the number of turning points and bars of the folded line are displayed based on the granularity on the x-axis, so their granularity needs to be consistent. You could set the quarter as a line, which would produce a baseline to measure each month against the average of the quarter, which would be statistically significant. Bars, on the other hand, show values by date or totaled by quarter, so that you can differentiate how much granularity there is at different times.Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Albert, thanks for looking into this with me. You're coming close but landing at the same issue I'm still having. If you're on Quarterly View, you still don't see the daily stock prices: each quarter only has an average stock price while I would like to see all data points plotted...
If I drill down to daily data, the quarters are plotted on each day. You cannot plot another measure in bars in that case as every day would then have two bars instead of each quarter having two bars.
Does this make sense?
You can also have a look here: https://finchat.io/company/NYSE-V/financials/cash-flow-statement/
Example screenshot:
Actually, I should get the below but the quarterly data plotted as bars and the bars aggregated over the full quarters iso bars on the quarter end dates:
Hi JasperVanGils ,
This doesn't make sense, in the Line and clustered column chart, the number of turning points and bars of the folded line are displayed based on the granularity on the x-axis, so their granularity needs to be consistent. You could set the quarter as a line, which would produce a baseline to measure each month against the average of the quarter, which would be statistically significant. Bars, on the other hand, show values by date or totaled by quarter, so that you can differentiate how much granularity there is at different times.Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly