About bTonyC

bTonyC · ‎11-07-2022

Thanks again Giuseppe!! I agree that Month is displayed correctly in Splunk Search. The issue appears when using a chart visualisation in Splunk Dashboard Studio. (See my previous screenshots to see what I mean) Dashboard Studio charts seem to convert "2022-10" into a Date/time and displays that. This is the core issue. Regards, Tony

bTonyC · ‎11-07-2022

Thanks Giuseppe, I ended up doing something very similar to get the ordering correct. (Convert string to a date then back to a string for display) Any idea why October displays as a full dates when they are all just strings "2022-10"??? Further experimenting shows that the hyphen is the trigger. If I use another character, this problem doesn't happen. eg. "2022>10" Thanks, Tony

bTonyC · ‎11-06-2022

I use some strings in data to represent months. eg "2022-1" Run this in Search: | makeresults format=csv data="Month 2022-1 2022-1 2022-7 2022-7 2022-7 2022-8 2022-9 2022-9 2022-9 2022-10 2022-10 2022-10 2022-10 2022-9" | stats count by Month | sort Month You get: Now use the Splunk query in Dashboard Studio for a Bar Chart: Why is October ("2022-10") being treated as a date suddenly???? Is this Bug or a Feature? I tried changing the strings to have a leading Zero for the month. eg. "2022-01" They are ALL then treated as Dates. How do I avoid this? Thanks for your help

bTonyC · ‎10-17-2022

Hello, I am seeing exactly the same behaviour that you have described. When I click on the visualization, the URL in the address bar changes (I can see the parameter change to the correct value) but it immediately changes back to what it was (default?) The content of the dashboard does not even attempt to update. Using the Multiselect works fine. Changes the chart visualisation. Can we use the same token for the multiselect as we use in the chart drilldown?? That is what I want to do. Thanks

Posts	4
Solutions	0
Karma Given	4
Karma Received	0
Member Since	‎10-17-2022

Online Status	Offline
Date Last Visited	‎11-08-2022 11:01 PM

Why is my Dashboard converting strings into dates?

Re: Dashboard converting strings into dates

Re: Dashboard converting strings into dates

Why is my Dashboard converting strings into dates?

Re: Connecting drilldown and multiselect/dropdown ...